Description
Adds a specified number of empty rows to a query.
Returns
The number of rows in the query
QueryAddRow(query [, number])
See also
QueryAddColumn, QuerySetCell, QueryNew; Creating a recordset with the QueryNew() function in the Developing ColdFusion Applications
Parameters
Parameter |
Description |
|---|---|
query |
Name of an executed query. |
number |
Number of rows to add to the query. The default value is 1. |
Usage
Enhancements in ColdFusion 10 lets you specify a struct, an array of structs, or arrays with single or multiple dimensions to add rows to the query as shown in the following example:
queryAddRow(myQuery1,
[
{id=2,name="Two"},
{id=3,name="Three"},
{id=4,name="Four"}
]);
queryAddRow(myQuery2,{id=4,name="Four"});
queryAddRow(myQuery1,
[
[1,"One"],
[2,"Two"],
[3,"Three"]
]);
<h3>QueryAddRow Example</h3> <!--- start by making a query ---> <cfquery name = "GetCourses" datasource = "cfdocexamples"> SELECT Course_ID, Number, 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 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# #Number# #Descript#</pre> </cfoutput>
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.