CFML Reference
ColdFusion Functions

IsQuery

Description

Determines whether value is a query.

Return value

True, if value is a query.

Category

Decision functions, Query functions

Syntax

IsQuery(value)

See also

QueryAddRow

Parameters

Parameter	Description
value	Query variable

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 = "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>

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6

Comments are no longer accepted for ColdFusion MX. ColdFusion 8 is the current version.

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt1139.htm

Add Comment