ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:adodb_getone_eof

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
v5:reference:adodb_getone_eof [2016/01/13 02:30] – ↷ Page moved from reference:adodb_getone_eof to v5:reference:adodb_getone_eof mnewnhamv5:reference:adodb_getone_eof [2023/06/19 15:27] (current) – [Syntax] Remove empty comment in code sample dregad
Line 9: Line 9:
 </WRAP> </WRAP>
  
-This is a global variable that determines what the [[reference: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. +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  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 
Line 17: Line 17:
  
 <code php> <code php>
-/* 
-* 
-*/ 
 $ADODB_GETONE_EOF = null; $ADODB_GETONE_EOF = null;
 +
 $test = $db->getOne('select character_field from table where integer_field=1');   $test = $db->getOne('select character_field from table where integer_field=1');  
  
Line 26: Line 24:
 { {
     /*     /*
-    * We did not find any records that matched the value of integer_1=1+    * We did not find any records that matched the value of integer_field=1
     */     */
 } }
Line 32: Line 30:
 { {
    /*    /*
-    * We did not find any records OR the first record found that matched integer_1=1 +    * We did not find any records OR the first record found that matched  
-    * had a character_1 value of null+    * integer_field=1 had a character_field value of null
     */     */
 } }
v5/reference/adodb_getone_eof.1452648615.txt.gz · Last modified: 2017/04/21 11:31 (external edit)