Contents > CFML Reference > ColdFusion ActionScript Functions > CF.query

CF.query

Performs queries against ColdFusion data sources.

Returns a RecordSet object.W

CF.query
   ({
      datasource:"data source name", 
      sql:"SQL stmts", 
      username:"username", 
      password:"password",
      maxrows:number, 
      timeout:milliseconds
   })

Arguments

You can code the CF.query function using named or positional arguments. You can invoke all supported arguments using the named argument style, as follows:

CF.query({datasource:"datasource", sql:"sql stmt",
   username:"username", password:"password", maxrows:"maxrows",
   timeout:"timeout"});

Note: The named argument style uses curly braces {} to surround the function arguments.

Positional argument style, which is a shorthand coding style, does not support all arguments. Use the following syntax to code the CF.query function using positional arguments:

CF.query(datasource, sql);
CF.query(datasource, sql, maxrows);
CF.query(datasource, sql, username, password);
CF.query(datasource, sql, username, password, maxrows);

Note: Do not use curly braces {} with positional arguments.

You can manipulate the record set returned by the CF.query function using methods in the RecordSet ActionScript class. The following are some of the methods available in the RecordSet class:

• RecordSet.getColumnnames
• RecordSet.getLength
• RecordSet.getItemAt
• RecordSet.getItemID
• RecordSet.sortItemsBy
• RecordSet.getNumberAvailable
• RecordSet.filter
• RecordSet.sort

For more information on using server-side ActionScript, see Using Server-Side ActionScript of Developing ColdFusion MX Applications. For more detailed information about the RecordSet ActionScript class, see Using Flash Remoting.

// Define a function to do a basic query
// Note use of positional arguments
function basicQuery()
{
   result = CF.query("myquery", "cust_data", "SELECT * from tblParks");
   return result;
}

// Example function declaration using named arguments
function basicQuery()
{
   result = CF.query({datasource:"cust_data", sql:"SELECT * from tblParks"});
   return result;
}

// Example of the CF.query function using maxrows argument
function basicQueryWithMaxRows()
{
   result = CF.query("cust_data", "SELECT * from tblParks", 25);
   return result;
}

// Example of the CF.query function with username and password
function basicQueryWithUser()
{
   result = CF.query("cust_data", "SELECT * from tblParks", 
      "wsburroughs", "migraine1");
   return result;
}

Contents > CFML Reference > ColdFusion ActionScript Functions > CF.query

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/ssasfun2.htm

Add Comment