MDB2 autoExecute questions

[Howler9443]

Hello everyone,

I'm new to these forums as well as using MDB2. I am attempting to convert a legacy app to something a lot easier to manage.

I am using PHP 5.1 w/MSSQL compiled in along with SQL Server 2000. I converted the app from PEAR:😃B to PEAR::MDB2 or at least I am still working on it.

I am receiving a "syntax error" when I try to perform an autoExecute. I would like to know if there is a way to view the query that is generated by autoExecute so that I can debug this.

Here is how I am attempting to use autoExecute where

testtable is the name of the table.
arrAssocTest is associative array

$res = $db->autoExecute('testtable', $arrAssocTest, MDB2_AUTOQUERY_UPDATE, "id = 1");

Is viewing the generated query possible? Or is there a better technique?

Any advice would be most helpful.

Thanks,
Howler9443

[Howler9443]

I found a few methods to help with this issue.

Once the error is thrown and inside the error handling code I simply added the following line to display the query that was being executed.

echo $res->getDebugInfo();

This dumped the entire query to my browser and has allowed me to continue debugging the application.

Thanks