Last updated on
Apr 27, 2021 06:03:08 AM GMT
|
Also Applies to ColdFusion
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
Function syntax
QuerySetCell(query, column_name, value [, row_number ])
See also
QueryAddColumn, QueryAddRow, QueryNew; Creating a recordset with the QueryNew() function in About recordsets in the Developing ColdFusion Applications
History
ColdFusion MX 7: Changed the behavior of the function so that it does type validation.
Parameters
Parameter |
Description |
---|---|
query |
Name of an executed query. |
column_name |
Name of a column in the query. |
value |
Value to set in the cell. |
row_number |
Row number. The default value is last row. |
Example
<cfscript> myQuery=QueryNew("ID,Name,Value","integer,varchar,integer"); // Display an empty recordset WriteOutput("Empty query object:"); WriteDump(myQuery); // Create a struct for row values myStruct=StructNew(); myStruct={ID=001,Name="George",Value=100}; // Create an empty struct for values in row 2 myStruct2=StructNew(); myStruct2={}; // Add values for row 1 QueryAddRow(myQuery,myStruct); WriteOutput("Recordset with row 1 and empty row 2:"); // Add values for row 2 QueryAddRow(myQuery,myStruct2); // Result with one row with values and second row empty WriteDump(myQuery); // Set cell value for row 2 QuerySetCell(myQuery,"ID","002",2); QuerySetCell(myQuery,"Name","John",2); // Display complete recordset with row 1 and 2 populated WriteOutput("Recordset with cell values set in rows 1 and 2:"); WriteDump(myQuery); </cfscript>
Output

Using member function
<cfscript> myQuery=QueryNew("ID,Name,Value","integer,varchar,integer"); myStruct=StructNew(); myStruct={ID=001,Name="George",Value=100}; QueryAddRow(myQuery,myStruct); myStruct2={}; QueryAddRow(myQuery,myStruct2); myQuery.setCell("ID","002",2); myQuery.setCell("Name","Peter",2); myQuery.setCell("Value","200",2); WriteDump(myQuery); </cfscript>
Sign in to your account