Support Joomla!

references:joomla.framework:database:jdatabase-geterrornum

Table of Contents

getErrorNum

API Package Subpackage Class Method Reference Last reviewed Doc status
API Home Package Joomla.Framework Subpackage Database Class JDatabase Method getErrorNum Reference getErrorNum() Never Work in Progress

Returns the most recent database error code. See also JDatabase->stderr.

Syntax

int getErrorNum ()

Examples

Example

$database =& JFactory::getDBO();
$query = "SELECT * FROM 'bad_table'";
$database->setQuery( $query );
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
  echo 'Error ' . $database->getErrorNum() . ': ' . $database->getErrorMsg();
}

might produce:

Result

Error 1064: You have an error in your SQL syntax near \'\'bad_table\'\'
        at line 1 SQL=SELECT * FROM \'bad_table\'

Discussion

Full name:
E-Mail:
 
references/joomla.framework/database/jdatabase-geterrornum.txt (642 views) · Last modified: 2007/08/15 14:52