MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION MX, Reference

Page: 800 / 1108

800 Chapter 3: ColdFusion Functions
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 = Co 1>
<cfset Temp = QuerySetCell(GetCourses, "Number", 100*CountVar)>
<cfset CountVar = Co 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>
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.