Generally I tend to dump the content of the SQL query string that's passed to the database to screen and then dump the result code from the query to the screen.
Once you've captured the query, run this from a SQL query console as this will give you better visibility of any errors. |