#CQL

Syntax

#CQL(Variable,Query)

Parameters

• Variable - The variable to store the cQL query results in.  The variable name should include the preceding dollar sign.
• Query - A string or variable with the cQL query.

Description

Executes a cQL query, and stores the results in a variable.  Use #LIST to iterate through the results.

Related: #LIST, #CPATH, #SQL

Example

#CQL($Results,"SELECT Name FROM Contact")
#LIST($Results)
$Name<br />
#ENDLIST

Result

John Smith<br />
Mary Joe<br />

• < #CPATH
• #CSCRIPT >