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>