Allaire: mySQL Client Variable Expiration
On Linux, the current versions of MySQL do not support subselects. ColdFusion uses this SQL syntax to expire client variable storage. As a result, cfexec will report an error when trying to expire client variables. Here's a workaround.
Allaire: mySQL Client Variable Expiration