User Guide

114 Chapter 6: Using Flash Remoting with ColdFusion MX
When using positional arguments, do not use curly braces.
Using CF.query()
The
CF.query() function lets you perform queries against any ColdFusion data source. The
CF.query() function maps closely to the cfquery CFML tag, although it currently supports a
subset of the
cfquery attributes.
You use the
CF.query() function to perform the following actions:
• Identify the data source you want to query
• Pass SQL statements to the data source
• Pass other optional parameters to the database
You can write the
CF.query() function using either named arguments or positional arguments.
The named argument style is a more readable style than the positional argument style. Although
the positional argument style supports a subset of
CF.query arguments, it allows a more compact
coding style that is appropriate for simple expressions of the
CF.query() function.
The
CF.query() function accepts the following arguments using the named argument style:
CF.query
({
datasource:"data source name",
sql:"SQL stmts",
username:"username",
password:"password",
maxrows:number,
timeout:milliseconds
})
The named argument style uses curly braces to surround the function arguments. The positional
argument approach supports a subset of
CF.query arguments, but it lets you code in a more
succinct and efficient style. The schema for the positional argument style is as follows:
CF.query(datasource, sql);
CF.query(datasource, sql, maxrows);
CF.query(datasource, sql, username, password);
CF.query(datasource, sql, username, password, maxrows);
When using positional arguments, do not use braces.
The
CF.query() function returns a RecordSet object to Flash. For more information about
working with RecordSet objects, see Chapter 4, “Using Flash Remoting Data in ActionScript,” on
page 63.