~~NOTOC~~
====== $ADODB_GETONE_EOF ======
|Type|mixed|
|Default|null|
This is a global variable that determines what the [[v5:reference:connection:getone|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
*/
}