Re: [PHP-DB] MDB2 help needed

2008-06-12 Thread James Lucas
obtain more info regarding the error (such as foreign key constraint incompatilibities). Obviously I can copy the query subsequently to SQLyog or another tool, but that takes more time. Yves -- Original Message -- Received: Thu, 12 Jun 2008 10:25:02 AM CDT From: Laura Longo <[EMAIL PROTECTE

Re: [PHP-DB] MDB2 help needed

2008-06-12 Thread YVES SUCAET
the error (such as foreign key constraint incompatilibities). Obviously I can copy the query subsequently to SQLyog or another tool, but that takes more time. Yves -- Original Message -- Received: Thu, 12 Jun 2008 10:25:02 AM CDT From: Laura Longo <[EMAIL PROTECTED]> To: php-db@lists.php

Re: [PHP-DB] MDB2 help needed

2008-06-12 Thread Laura Longo
Hi Yves, to understand if an error is occured you can use the static method Pear::isError($db) where $db is an instance of MDB2 object. To get the specific error you can use the MDB2 method getMessage() ($db->getMessage()). Hope this help, Laura > Hello, > > What's the equivalent of mysql_error

[PHP-DB] MDB2 help needed

2008-06-12 Thread YVES SUCAET
Hello, What's the equivalent of mysql_error() and mysql_errno() in MDB2? When I'm sending an incorrect SQL-statement to the server and it fails, all I'm getting is "MDB2 Error: syntax error". Thanks in advance, Yves Sucaet Iowa State University -- PHP Database Mailing List (http://www.php.ne