Sets a cell to a value. If no row number is specified,
the cell on the last row is set.
Lucee Function Reference
querysetcell()
Example
querysetcell(query query,string column_name,any value,[number row_number]):boolean
Category
query
Arguments
The arguments for this function are set. You can not use other arguments except the following ones.
| Name | Type | Required | Default Value | Description |
|---|---|---|---|---|
| query | query | Yes | Name of the query to update. | |
| column_name | string | Yes | Name of the column to update | |
| value | any | Yes | New value for the cell | |
| row_number | number | No | -9999 | Which row to update, defaults to the the last row in the query |