QueryRowData()

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

query object do get data from
rowNumber
number, required

position of the row to be returned
format
string, optional

struct or array

Alias: returnFormat

Introduced: 5.3.8.85

struct

Examples

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