queryAddRow

Description

Adds a specified number of empty rows to a query.

Categories

Query Functions

Related

queryAddColumn queryNew querySetCell

Syntax

QueryAddRow(query [, number])

Attributes

AttributeDescriptionRequiredDefault
numberNumber of rows to add to the query. The default value is 1.
queryName of an executed query.

Returns

The number of rows in the query

Example

<h3>QueryAddRow Example</h3> 
 
<!--- start by making a query ---> 
<cfquery name = "GetCourses" datasource = "cfdocexamples"> 
    SELECT Course_ID, Number, Descript  
    FROM Courses 
</cfquery> 
 
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 Temp = QuerySetCell(GetCourses, "Descript",  
    "Description of variable #Countvar#")> 
</cfloop> 
 
After the QueryAddRow action, the query has <CFOUTPUT>#GetCourses.RecordCount#</CFOUTPUT>  
records. 
<CFOUTPUT query="GetCourses">  
<PRE>#Course_ID# #Number# #Descript#</pre> 
</cfoutput>