ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== errorMsg ======
~~NOTOC~~
<WRAP right box>
== Syntax ==
  string errorMsg()
</WRAP>
===== Description =====
The function ''errorMsg'' returns an  unfriendly message about the last known error. The message may contain database specific notices.
-----------------------------
==== Usage ====
<code php>
/*
 * IBM DB2 database connection assumed
 */

/*
 * An invalid SQL statement with mis-matched quotes
 */
$SQL = 'SELECT * FROM ACT WHERE ACT_DESC = "1234';

/*
 * Execute the statement, suppressing any errors
 */
$desc = @$db->getOne($SQL);

/*
 * Get the last error message
 */
$e = $db->errorMsg();

print $e;

/*
 * returns: [IBM][CLI Driver][DB2/LINUXX8664] SQL0010N  The string constant 
 * beginning with "'ABCD" does not have an ending string delimiter.  SQLSTATE=42603 SQLCODE=-10
 * PHP Fatal error:  Call to a member function FetchRow() on boolean in /root/db2/test12.php on line 15
 */
</code>