User Guide
Chapter 2: ColdFusion Functions 401
IsQuery
Returns TRUE if value is a query.
See also QueryAddRow.
Syntax IsQuery(
value
)
value
Query variable.
Example <!--- Shows an example of IsQuery and IsSimpleValue --->
<HTML>
<HEAD>
<TITLE>
IsQuery Example
</TITLE>
</HEAD>
<BODY BGCOLOR=silver>
<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 --->
<RY NAME="getEmployees" DATASOURCE="cfsnippets">
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>
</BODY>
</HTML>