This is a mysql result set, i.e. Resource. You need to use the appropriate functions to get a row from this result set and you can use it as an array. See $modx->db->getRow() for more information.
First time using the api. I’m using the api with a select to find the site name from the system setting table. My code is returning Resource id #4. When I browse the database and table in phpMyAdmin I see the correct value. What am I missing? I’ve even tried just php and no api and get the same result.
echo "<pre>"; print_r($result); echo "</pre>";