Cold Fusion

ColdFusion: SQL Server – Cannot use empty object or column names. Use a single space if necessary

When upgrading from an OLD version of Coldfusion to a newer one.   We would occassionally receive the message

Cannot use empty object or column names. Use a single space if necessary

This message seemed as though it came from an error sent back from the database but the database version did not change at all.

However CF changed their version of SQL Server driver as the progressed and made it more compliant.   Basically they made it so that you could no longer use double quotes (“”) in order to enclose an empty string.

So the SQL query that may have worked before

select * from myusers where username <> “”

would need to become

select * from myusers where username <> ”