Type | mixed |
Default | null |
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_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 */ }