queryGetRow

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

queryGetRow( query, rowNumber ); → returns Struct

queryGetRow Argument Reference

query
Required

query object do get data from.

rowNumber
Required

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