QuerySetCell

Description

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

Syntax

QuerySetCell(query, column_name, value [, row_number ])

Parameters

Parameter

Description

query
Name of the query already executed

column_name
Name of the column in the query

value
Value to set in the cell

row_number
Row number. Defaults to last row.

Parameter	Description
query	Name of the query already executed
column_name	Name of the column in the query
value	Value to set in the cell
row_number	Row number. Defaults to last row.

Example

<!--- This example shows the use of QueryAddRow and QuerySetCell --->
<html>
<head>
<title>
QuerySetCell Example
</title>
</head>

<body>
<H3>QuerySetCell Example</H3>

<!--- start by making a query --->
<cfquery name = "GetCourses" datasource = "cfsnippets">
SELECT Course_ID, Course_Num, 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, "Course_ID", CountVar)>
 <cfset CountVar = CountVar + 1>
 <cfset Temp = QuerySetCell(GetCourses, "Course_Num", 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_Num#  #Descript#</PRE>
</cfoutput>

</body>
</html>

QuerySetCell

Description

Category

Syntax

See also

Parameters

Example

CFML Reference
ColdFusion Functions