$ADODB_GETONE_EOF

Typemixed
Defaultnull

This is a global variable that determines what the getOne() method returns if the SQL statement fails to match any records in a recordset. The value can be set or reset at any point in a script.

If the value that is being retrieved can return an empty or 0 value, it is important to do an exact comparison on the returned value to distinguish between queries where the value of the record found is empty and queries where no record is found


Syntax

$ADODB_GETONE_EOF = null;
 
$test = $db->getOne('select character_field from table where integer_field=1');  
 
if ($test === null)
{
    /*
    * We did not find any records that matched the value of integer_field=1
    */
}
if ($test == false)
{
   /*
    * We did not find any records OR the first record found that matched 
    * integer_field=1 had a character_field value of null
    */
}