Inside Coldfusion MX

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

Description

Sets a cell in a query to a value. If no row number is given, the cell in the last row is set.

Example

<cfset exampleQuery = QueryNew("ProductID, ProductType, SKU")> <cfset newQuery = QuerySetCell(exampleQuery, " ProductID", 1001)>