queryGetRow

Returns a struct having all the columns as keys and their corresponding values.

queryGetRow( query, rowNumber ); → returns Struct

Argument Reference for the queryGetRow function

query

Required: Yes
query object do get data from.

rowNumber

Required: Yes
position of the row to be returned.

Examples sample code invoking the queryGetRow function


Tag Syntax

<cfquery name="myQuery" result="myresult" datasource="artGallery" fetchclientinfo="yes" > 
 select * from art where ARTID ><cfqueryparam value="2" cfsqltype="CF_SQL_INTEGER"> 
 </cfquery> 
 <cfdump var='#myQuery#' > 
 <cfset data = queryGetRow(myQuery, 1) > 
 <cfdump var='#data#' > 

Fork me on GitHub