SQL Reserved Words

When ColdFusion 5 first introduced the ability to query queries it allowed reserved SQL words to be used as column names. This is no longer allowed in ColdFusion MX. If your original query returns invalid column names assign them aliases using AS and refer to the aliases when querying the query. (Applies to: ColdFusion MX)

Leave a Reply