QuerySetCell()
Sets a cell to a value. If no row number is specified, the cell on the last row is set.
You can add an entire row with data with QueryAddRow().
QuerySetCell( query=query, column_name=string, value=any, row_number=number );
Returns: Boolean
| Argument | Description | Default |
|---|---|---|
|
query
query,
required
|
edit
Name of an executed query. Alias: query |
|
|
column_name
string,
required
|
edit
Name of the column to populate. Alias: columnName |
|
|
value
any,
required
|
edit
The value to populate the query cell with. |
|
|
row_number
number,
optional
|
edit
Query row number to populate. Alias: row, number |
-9999 |
Examples
editq = queryNew( "id,name");
QueryAddRow(q);
QuerySetCell(q, "id", 1, 1);
QuerySetCell(q, "name", "one", 1);
dump(q);
See also
- Queries
- QueryAddRow()
- query.addRow()
- query.setCell()
- <cfqueryparam>
- Search Issue Tracker open_in_new
- Search Lucee Test Cases open_in_new (good for further, detailed examples)