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 a function in Using Query of Queries in ColdFusion MX 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>

View comments in LiveDocs