Inside Coldfusion MX

QueryAddRow (query [, number])

Description

Adds x number of empty rows to a query.

Example

<cfquery name = "exampleQuery" datasource = "exampleDB"> SELECT ProductName, SKU, InStock FROM Products </cfquery> <cfoutput> Example query has #exampleQuery.RecordCount# rows. </cfoutput> <cfset temp = QueryAddRow(exampleQuery, 5)> <cfoutput> Now Example query has #exampleQuery.RecordCount# rows. </cfoutput>