QuerySetCell

 

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

Query functions

Function syntax

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

See also

QueryAddColumnQueryAddRowQueryNewCreating 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>
<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>
<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

querysetcell output
querysetcell 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>
<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>
<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>

Get help faster and easier

New user?