ColdFusion 9.0 Resources |
QuerySetCellDescriptionSets 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. See alsoQueryAddColumn, QueryAddRow, QueryNew; Creating a recordset with the QueryNew() function in the Developing ColdFusion Applications 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> |