Adobe ColdFusion 8

QuerySetCell

Description

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

Starting with ColdFusion MX 7, you cannot add a string literal (for example, "All") to a column that is of type numeric, although this was allowed in previous versions of ColdFusion.

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 the QueryNew() function" in the ColdFusion Developer's Guide

History

ColdFusion MX 7: Changed the behavior of the function so that it does type validation.

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. The default value is last row.

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>