Why am I getting "Resource id #xx" with a custom query?

Any SELECT query returns a Resource object, which needs further processing to extract its values. The $modx->db API functions are just wrappers for the PHP MySQL functions.

http://svn.modxcms.com/docs/display/MODx096/select

There are several API functions to extract the values from the resource object.

Thanks Susan, got it resolved in the other thread...