QUERYSETCELL  
Description

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

 
Returns

True, if successful; False, otherwise.

 
Category

Query functions

 
Function syntax
QuerySetCell(query, column_name, value [, row_number ])
 
See also

QueryAddColumn, QueryAddRow, QueryNew; "Creating a record set with a function" in Chapter 22, "Using Query of Queries," in ColdFusion MX Developer's Guide

 
Parameters

 
Example
<!--- This example shows the use of QueryAddRow and QuerySetCell --->

<!--- start by making a query --->
<cfquery name = "GetCourses" datasource = "cfdocexamples">
   SELECT Course_ID, Descript 
   FROM Courses
</cfquery>
<p>The Query "GetCourses" has <cfoutput>#GetCourses.RecordCount#</cfoutput> 
rows.

<cfset CountVar = 0>
<cfloop CONDITION = "CountVar LT 15">
   <cfset temp = QueryAddRow(GetCourses)>
   <cfset CountVar = CountVar + 1>
   <cfset Temp = QuerySetCell(GetCourses, "Number", 100*CountVar)>
   <cfset CountVar = CountVar + 1>
   <cfset Temp = QuerySetCell(GetCourses, "Descript", 
"Description of variable #Countvar#")>
</cfloop>

<P>After the QueryAddRow action, the query has
   <CFOUTPUT>#GetCourses.RecordCount#</CFOUTPUT> 
   records. 
   <CFOUTPUT query="GetCourses"> 
   <PRE>#Course_ID# #Course_Number# #Descript#</pre> </cfoutput>

Name of an executed query.

QUERY  

Name of a column in the query.

COLUMN_NAME  

Value to set in the cell.

VALUE  

Row number. The default value is last row.

ROW_NUMBER