Ok, thanks to this article: http://awads.net/wp/2006/02/21/lobs-gotcha-in-coldfusion/
I found the problem...which was not in the code, it was a setting in CF Administrator. The jist of the link/article is there is under the Data Source where your query is pointing to, under advanced settings there is an option to enable Blob and Clob. You must enabled. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3249 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
