> That's why I'm asking...there is no cf_sql_text. Yes there is.
I've just tried it to be certain, and it works fine. If you really want to use something listed on the Livedocs page, you can go with cf_sql_clob (because that's ultimately what the MySQL Text types are). Don't think it ultimately matters whether you do _clob or _text, (except perhaps if you're near the limits?). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3297 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm