querySetCell

Sets a cell to a value. If no row number is specified,
the cell on the last row is set.

querySetCell(query, column, value [, row]) → returns boolean

Argument Reference for the querySetCell function

query

Required: Yes

column

Required: Yes

value

Required: Yes

row

Required: No

Examples sample code invoking the querySetCell function


Tag Example

<!--- start by making a query ---> 
 <cfquery name = "GetCourses" datasource = "cfdocexamples"> 
 SELECT Course_ID, Descript 
 FROM Courses 
 </cfquery> 
<cfset temp = queryAddRow(GetCourses)> 
<cfset Temp = querySetCell(GetCourses, "Number", 100*CountVar)> 

Fork me on GitHub