Host Variables

Previous Next

See Also

Host variables are used in SELECT and WHERE clauses of a SQL query, to refer to a literal value set by a call to the setHostVar() function preceding the event call that triggers this query.

:name

Or

:"Name"

Any non-empty value may be used for the host variable name, although if the name contains spaces it must be enclosed by double quotes ("x x"), and double quotes may not be part of its name.

EXAMPLE:

For an example of a SQL statement that uses host variable placeholders, See Also: Host Variable Functions.