ADOdb

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

~~NOTOC~~ 
====== $ADODB_GETONE_EOF ======

<WRAP right box round>

|Type|mixed|
|Default|null|

</WRAP>

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 =====

<code php>
$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
    */
}
</code>