QueryAddRow

Description

Adds a specified number of empty rows to a query.

Return value

The number of rows in a query

Category

Query functions

Syntax

QueryAddRow(query [, number ]) 

See also

QueryAddColumn, QueryAddRow, QuerySetCell, QueryNew

Parameters

Parameter Description
query
Name of an executed query.
number
Number of rows to add to the query. Default: 1.

Example

<h3>QueryAddRow Example</h3>

<!--- start by making a query --->
<cfquery name = "GetCourses" datasource = "cfsnippets">
  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>

Comments