Returns TRUE if value is a query.
IsQuery(value)
Parameter |
Description |
---|---|
value |
Query variable |
<!--- 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 ---> <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> </body> </html>