I'm wondering what the best way is to get the sql generated by cfquery and then sent to the database. A sql statement that I'm using throws an error, so CF doesn't show the generated sql in the debugging info (only the sql error message thrown by SQL Server and passed into CF). Is there a way to get that info in a log file or to output on the screen? Please let me know. Thanks! Tony
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm