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
Examples
q = 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
- Search Lucee Test Cases (good for further, detailed examples)