MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION MX, Reference

Page: 682 / 1108

682 Chapter 3: ColdFusion Functions
IsQuery
Description
Determines whether value is a query.
Returns
True, if value is a query.
Category
Decision functions , Query functions
Function syntax
IsQuery ( value )
See also
QueryAddRow
Parameters
Example
<!--- Shows an example of IsQuery and IsSimpleValue --->
<h3>IsQuery Example</h3>
<!--- define a variable called "GetEmployees" --->
<CFPARAM name = "GetEmployees" DEFAULT = "#Now()#">
<p>Before the query is run, the value of GetEmployees is
<cfoutput>#GetEmployees#</cfoutput>
<cfif IsSimpleValue(GetEmployees)>
<p>GetEmployees is currently a simple value
</cfif>
<!--- make a query on the snippets datasource --->
<cfquery name = "GetEmployees" datasource = "cfdocexamples">
SELECT *
FROM employees
</cfquery>
<p>After the query is run, GetEmployees contains a number of rows
that look like this (display limited to three rows):
<cfoutput QUERY = "GetEmployees" MaxRows = "3">
<pre>#Emp_ID# #FirstName# #LastName#</pre>
</cfoutput>
<cfif IsQuery(GetEmployees)>
GetEmployees is no longer a simple value, but the name of a query
</cfif>
Parameter Description
value Query variable