Differences

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

--- v5:reference:recordset:fetchobj [2016/01/28 18:00] – [Usage] mnewnham
+++ v5:reference:recordset:fetchobj [2023/06/11 11:40] – [Description] describe difference between fetchObj/fetchObject, remove invalid mention of advancing cursor dregad
@@ Line 1: / Line 1: @@
 ====== fetchObj =======
+====== fetchObject =======
 ~~NOTOC~~
 <WRAP right box>
   obj fetchObj(
       optional bool $upperCaseKeys=false
+      )
+  obj fetchObject(
+      optional bool $upperCaseKeys=true
       )
 </WRAP>
 ===== Description =====
-The function ''fetchObj()'' returns the current row of a recordset as an ADOFetchObj object or false if past end-of-file and advances the pointer of the result. If the end-of-file is reached, the ''EOF'' attribute is set.
+The ''fetchObj()'' / ''fetchObject()'' function returns the current row of a RecordSet as an ADOFetchObj object, or //false// if past end-of-file.
+They can be considered as aliases, except for the fact that ''fetchObject()'' converts the field names to uppercase by default, whereas ''fetchObj()'' does not.
 Unlike the [[v5:reference:recordset:fetchNextObj()]] method, the record pointer is not advanced. It is recommended that the 2 methods are not mixed in the same procedure.
+If the SQL statement results in an empty recordset, then calling fetchObj() will return an empty record, not EOF. Use [[v5:reference:connection:recordcount|recordCount()]] to ensure that you have retrieved a record.
 Results are influenced both by the [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant and [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] attribute.
 The ADOFetchObj object has no special functionality, but the method is useful when the recordset data needs to be converted into e.g. JSON
 -------------------
 ===== Usage =====