IsSimpleValue

Returns TRUE if value is a string, number, Boolean, or date/time value.

Syntax

IsSimpleValue(value)

value

Variable or expression.

Example

<!--- Shows an example of IsQuery and IsSimpleValue --->
<HTML>
<HEAD>
<TITLE>
IsSimpleValue Example
</TITLE>
</HEAD>

<BODY bgcolor=silver>
<H3>IsSimpleValue Example</H3>

<!--- define a variable called "getEmployees" --->
<CFIF NOT IsDefined("getEmployees")>
    <CFSET getEmployees="#Now()#">
</CFIF>

<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="HRApp">
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>#Employee_ID# #FirstName# #LastName#</PRE>
</CFOUTPUT>

<CFIF IsQuery(getEmployees)>
GetEmployees is no longer a simple value, but the name of a query
</CFIF>

</BODY>
</HTML>