Determines whether value is a query.
Decision functions, Query functions
IsQuery(value)
Parameter | Description |
---|---|
value |
Query variable |
<!--- 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>