QueryNew

Description

Returns an empty query with a set of columns or an empty query. See Usage for more information.

Syntax


QueryNew(columnlist)

Parameters

Parameter

Description

columnlist
Comma-separated list of columns to add to the query or an empty string.

Parameter	Description
columnlist	Comma-separated list of columns to add to the query or an empty string.

Usage

If you specify an empty string, you can add a column to the query and populate its rows with the contents of a one-dimensional array using QueryAddColumn.

Example

<!--- This example shows the use of QueryNew --->

<html>

<head>

<title>QueryNew Example</title>

</head>

<body>

<H3>QueryNew Example</H3>

<P>We will construct a new query with two rows:

<cfset myQuery = QueryNew("name, address, phone")>

<!--- make some rows in the query --->

<cfset newRow  = QueryAddRow(MyQuery, 2)>

<!--- set the cells in the query --->

<cfset temp = QuerySetCell(myQuery, "name", "Fred", 1)>

<cfset temp = QuerySetCell(myQuery, "address", "9 Any Lane", 1)>

<cfset temp = QuerySetCell(myQuery, "phone", "555-1212", 1)>

<cfset temp = QuerySetCell(myQuery, "name", "Jane", 2)>

<cfset temp = QuerySetCell(myQuery, "address", "14 My Street", 2)>

<cfset temp = QuerySetCell(myQuery, "phone", "588-1444", 2)>

<!--- output the query --->

<cfoutput query = "myQuery">

<PRE>#name#  #address#  #phone#</PRE>

</cfoutput>  

To get any item in the query, we can output it individually

<cfoutput>

<P>Jane's phone number: #MyQuery.phone[2]#

</cfoutput>

</body>

</html> 

QueryNew