QueryRowData()

edit

Returns a struct with the data from a query for a given row number

QueryRowData( query=query, rowNumber=number, format=string );

Returns: any

Argument Description Default
query
query, required 		edit

query object do get data from
rowNumber
number, required 		edit

position of the row to be returned
format
string, optional 		edit

struct or array

Alias: returnFormat

Introduced: 5.3.8.85

struct

Examples

edit 
q = queryNew( "id,name","int,varchar");
q.addRow(4);
q.setCell("id", 1, 1);
q.setCell("id", 2, 2);
q.setCell("id", 3, 3);
q.setCell("id", 4, 4);
q.setCell("name", "one", 1);
q.setCell("name", "two", 2);
q.setCell("name", "three",3);
q.setCell("name", "four", 4);
dump(q);
dump(QueryRowData(q, 2));

See also