querySetCell

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

querySetCell(query, column, value [, row]) → returns boolean

  1. CFDocs
  2. Functions
  3. Query Manipulation Functions
  4. querySetCell
  5. CF3+
  6. Lucee
  7. BD
  8. 0 Issue
  9. Edit
See Also:   QueryAddColumn   QueryAddRow   QueryNew

Argument Reference

query query
Required

column string
Required

value any
Required

row numeric

Examples
Sample code invoking the querySetCell function 

<!--- start by making a query ---> 
 <cfquery name = "GetCourses" datasource = "cfdocexamples"> 
 SELECT Course_ID, Descript 
 FROM Courses 
 </cfquery> 
<cfset temp = queryAddRow(GetCourses)> 
<cfset Temp = querySetCell(GetCourses, "Number", 100*CountVar)>

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub