QueryGetRow

QueryGetRow(query, rowNum)

<cfscript>
       myQuery=QueryNew("ID,Name,Rating","integer,varchar,double");
       myFirstData=StructNew();
       myFirstData={ID=1,Name="Nixon",Rating=56.87};
       QueryAddRow(myQuery,myFirstData);
       WriteOutput("Recordset updated with struct data:");
       WriteDump(myQuery);
       myGet=QueryGetRow(myQuery,1);
       WriteOutput("Returns struct with columns as keys:");
       WriteDump(myGet);
       //Try to return struct values for row=2 that does not exist
       try{
             QueryGetRow(myQuery,2);
       }
       catch(any q){
             WriteOutput(q.message);// Displays appropriate message
       }
</cfscript>

<cfscript>
       myQuery=QueryNew("ID,Name,Rating","integer,varchar,double");
       myFirstData=StructNew();
       myFirstData={ID=1,Name="Nixon",Rating=56.87};
       QueryAddRow(myQuery,myFirstData);
       myRow=myQuery.getRow(1);
       WriteDump(myQuery);
</cfscript>