Error “the SQL constructed is invalid” | cfproperty , ORM-enabled CFCs | ColdFusion 9Products affected
Issue
ColdFusion throws an exception "SQL constructed is invalid" if the table name has spaces in the SQL assigned to formula attribute of cfproperty.
Solution
Ensure that you do not use brackets for table names when there are spaces in the table name. Instead, use aliases for table names.
Additional information
cfproperty has an attribute formula that is assigned a SQL statement that computes a value of the column in a table. If the SQL for the property has a table name with a space escaped by brackets, ColdFusion throws an exception.
Example:
<cfproperty name="formulacol" formula="select count(*) from [table with space]">
Doc ID
(cpsid_51772)
Last updated
2011-03-22
Products affected
