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 syntaxQuerySetCell(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> |
QUERY | |
COLUMN_NAME | |
VALUE | |
ROW_NUMBER | |