SQL statements within a tag are often generated dynamically, and although ColdFusion knows what the final SQL is (and can display it within the page debug output) there is no way for ColdFusion developers to obtain this information. The workaround? Build the dynamic SQL as a variable (essentially a big string) and pass just that one variable to – this way you can access that variable if you need the SQL. (Applies to: ColdFusion All)

Leave a Reply