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~~ 
====== $ADOConnectionDefinitions::getOneEOF ======

<WRAP right box round>

|Type|mixed|
|Default|null|

</WRAP>

This is a class variable that determines what the [[v6: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>

$acd = new ADOdb\database\drivers\mysqli\ADOConnection
/*
*
*/
$acd->getOneEOF = 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
    */
}
</code>