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
Parameters
Parameter | Description
query | Name of an executed query
column_name | Name of a column in the query
value | Value to set in the cell
row_number | Row number. Default: last row.
Example
    <!--- This example shows the use of QueryAddRow and QuerySetCell --->

    <!--- start by making a query --->
    <cfquery name = "GetCourses" datasource = "cfsnippets">
       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>

query |
Name of an executed query

column_name |
Name of a column in the query

value |
Value to set in the cell

row_number |
Row number. Default: last row.