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>       

1