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

/*
*
*/
$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_1=1
    */
}
if ($test == false)
{
   /*
    * We did not find any records OR the first record found that matched integer_1=1
    * had a character_1 value of null
    */
}