Differences

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

--- v5:reference:recordset:fetchobj [2023/06/11 11:56] – [Description] returns an empty object, not false dregad
+++ v5:reference:recordset:fetchobj [2023/06/11 12:00] – [Description] check EOF flag dregad
@@ Line 17: / Line 17: @@
 ===== Description =====
-The ''fetchObj()'' / ''fetchObject()'' function returns the current row of a RecordSet as an ADOFetchObj object.
+The ''fetchObj()'' / ''fetchObject()'' functions return the current row of a RecordSet as an ADOFetchObj object.
 They can be considered as aliases, except for the fact that ''fetchObject()'' converts the field names to uppercase by default, whereas ''fetchObj()'' does not.
@@ Line 23: / Line 23: @@
 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 or if the recordset has moved past end of file, then calling fetchObj() will return an empty record, not EOF. Use [[v5:reference:connection:recordcount|recordCount()]] to ensure that you have retrieved a record.
+If the SQL statement results in an empty recordset or if the recordset has moved past end of file, then calling fetchObj() will return an empty record. Use [[v5:reference:connection:recordcount|recordCount()]] or check the EOF flag 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.