cfquery

From CEW

[edit] background

The background attribute allows page processing to continue whilst the query is executed in the background. It is equivalent to creating a new thread for the query to run in.

In BlueDragon's implementation, all backgrounded queries share a common thread.

Supported by:

[edit] psq

The PSQ attribute allows you to override the default cfquery behaviour of escaping all single quotes. Setting PSQ to true has the effect of wrapping the whole query contents with the PreserveSingleQuotes function.

Note: This attribute should be used with caution, as it has the potential to allow SQL injection attacks that might otherwise be blocked.

Supported by:

[edit] Query of Queries

ColdFusion MX added support for extra SQL statements such as DISTINCT and UNION.

BlueDragon does not yet support these extra statements.

Railo uses HSQL for Query of Queries to support an extended set of syntax, including DISTINCT and UNION.