Lucee Function Reference

queryaddrow()

Adds a specified number of empty rows to a query.

Example

queryaddrow(query query,[any numberOrData]):number

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 an executed query.  
numberOrData any  No 1 Number of rows to add to the query or a struct/array containing the data to populate the row.
Example:
queryAddRow(qry,3);
queryAddRow(qry,["Susi",20]);
queryAddRow(qry,{name:"Susi",age:20});