Adobe ColdFusion 8

QueryAddRow

Description

Adds a specified number of empty rows to a query.

Returns

The number of rows in the query

Category

Query functions

Function syntax

QueryAddRow(query [, number])

See also

QueryAddColumn, QueryAddRow, QuerySetCell, QueryNew; "Creating a record set with the QueryNew() function" in the ColdFusion Developer's Guide

Parameters

Parameter

Description
query

Name of an executed query.
number

Number of rows to add to the query. The default value is 1.

Example

<h3>QueryAddRow Example</h3>

<!--- start by making a query --->
<cfquery name = "GetCourses" datasource = "cfdocexamples">
    SELECT Course_ID, Descript 
    FROM Courses
</cfquery>
<p>The Query "GetCourses" has <cfoutput>#GetCourses.RecordCount#</cfoutput> rows.

<cfset CountVar = 0>
<cfloop CONDITION = "CountVar LT 15">
    <cfset temp = QueryAddRow(GetCourses)>
    <cfset CountVar = CountVar + 1>
    <cfset Temp = QuerySetCell(GetCourses, "Number", 100*CountVar)>
    <cfset CountVar = CountVar + 1>
    <cfset Temp = QuerySetCell(GetCourses, "Descript", 
    "Description of variable #Countvar#")>
</cfloop>

<P>After the QueryAddRow action, the query has
    <CFOUTPUT>#GetCourses.RecordCount#</CFOUTPUT> 
    records. 
    <CFOUTPUT query="GetCourses"> 
    <PRE>#Course_ID# #Course_Number# #Descript#</pre> </cfoutput>