The fetchAssoc() function returns the record as an associative array: "field" => value.
Syntax
fetchAssoc()
Arguments
No arguments.
Return value
Returns the record as an associative array: "field" => value.
Null, if there are no matching records.
Example
Dim rs,data
set rs = DB_Query("select * from carsmake")
do while bValue(doAssignmentByRef(data,rs.fetchAssoc()))
ResponseWrite ArrayElement(data,"id")
ResponseWrite ArrayElement(data,"make")
loop
See also:
•QueryResult object: fetchAssoc()
•QueryResult object: fetchNumeric()