queryRowData

Returns the cells of a query row as a structure

queryRowData(query, rowNumber) → returns struct

Member Function Syntax

query.rowData(rowNumber)

This function requires Lucee.  Not supported on Adobe ColdFusion, etc.

queryRowData Argument Reference

query query
Required

rowNumber numeric
Required

Examples
Sample code invoking the queryRowData function

Here we've a example to get the particular row value from myquery.

<cfset myQuery = queryNew("id,name,age","integer,varchar,integer",[[1,"Dharshini",20],[2,"Subash",18]])>
<cfdump var="#queryGetRow(myQuery,2)#" />

We've example to get the particular row value from myquery using script syntax.

<cfscript>
var myQuery = queryNew("id,title,author","integer,varchar,varchar",[[1,"Charlottes Web","E.B. White"],[3,"The Outsiders","S.E. Hinton"],[4,"Mieko and the Fifth Treasure","Eleanor Coerr"]]);
writeDump(myQuery.getRow(3));
</cfscript>

Fork me on GitHub