User Guide

148 Chapter 2: ColdFusion Tags

access="remote"

returnType="query"

hint="This query returns all records in the employee database. It can

drill-down or narrow the search, based on optional input parameters.">

For information on using the cffunction tag for ColdFusion components, see Chapter 11,

“Building and Using ColdFusion Components,” in Developing ColdFusion MX Applications.

If you specify a

roles attribute, the function executes only if a user is logged in and belongs to

one of the specified roles.

If you specify

variableName for the returnType attribute, the function must return a string that

is in ColdFusion variable name format; that is, the function must return a string that starts with a

letter, underscore, or Unicode currency symbol, and consist of letters, numbers, and underscores

(_), periods, and Unicode currency symbols, only. ColdFusion does not check whether the value

corresponds to an existing ColdFusion variable.

Example

<cfquery

name="empQuery" datasource="ExampleApps" >

SELECT FIRSTNAME, LASTNAME, EMAIL

FROM tblEmployees

</cfquery>

</cffunction>

<cfquery

name="deptQuery" datasource="ExampleApps" >

SELECT *

FROM tblDepartments

</cfquery>

</cffunction>

</cfcomponent>