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

QueryAddColumnQuerySetCellQueryNewCreating 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"] 
]);

Example

<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>

Example

The following example first creates an empty recordset. Then it creates a struct with key-value pairs that represent rows in the query recordset. Finally the rows are populated with the struct data.

<cfscript>
       myTeam=QueryNew("Jersey,Player_Name,Matches_Played","integer,varchar,integer"); //Create empty recordset myTeam
       //Display query headers
       WriteOutput("Empty query recordset:");
       WriteDump(myTeam);
       /*Now add rows and populate rows with data. Create a struct with data*/
       RealMadrid=StructNew();
       RealMadrid={Jersey=1,Player_Name="Keylor Navas",Matches_Played=50};
       QueryAddRow(myTeam,RealMadrid);
       //Add more data to Real Madrid
       RealMadrid={Jersey=7,Player_Name="Cristiano Ronaldo",Matches_Played=75};
       //Add the updated struct as data in myTeam
       QueryAddRow(myTeam,RealMadrid);
       WriteOutput("Record with rows added:");
       WriteDump(myTeam);
</cfscript>

Output

QueryAddRow

Using member function

<cfscript>
       myQuery=QueryNew("ID, Name, Age","integer,varchar,integer");
       // Add rows and populate rows with struct data
       people=StructNew();
       people={ID=50,Name="John Doe",Age=30};
       myQuery.addRow(people);
       WriteDump(myQuery);
</cfscript>

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy