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>
Summary of Contents for COLDFUSION 4.5-CFML LANGUAGE
Page 1: ...Allaire Corporation CFML Language Reference ColdFusion 4 5...
Page 207: ...Chapter 1 ColdFusion Tags 183 CFCATCH CFTRY BODY HTML...
Page 224: ...200 CFMLLanguageReference CFOUTPUT P Text within CFOUTPUT is always shown CFOUTPUT BODY HTML...
Page 336: ...312 CFMLLanguageReference CFIF BODY HTML...
Page 404: ...380 CFMLLanguageReference DE It is morning CFOUTPUT P BODY HTML...
Page 413: ...Chapter 2 ColdFusion Functions 389 Customer BalanceDue BR CFOUTPUT CFIF BODY HTML...
Page 483: ...Chapter 2 ColdFusion Functions 459 CFOUTPUT CFLOOP BODY HTML...
Page 584: ...560 CFMLLanguageReference...
Page 594: ...570 CFMLLanguageReference...
