Also, I wonder if it really matters given that I'm dealing with a text field that can take 65000+ characters. As long as I have the cfqueryparam tag to prevent SQL injection, does the addition of the CFSQLType parameter make any real difference with a "text" field?
It seems like there are a few different answers to my original question so I guess I'm just trying to avoid the issue, if possible. Rich On Mar 10, 2010, at 1:00 PM, Rich wrote: > > Where in the docs do you see cf_sql_text? > > Rich > > > On Mar 10, 2010, at 12:36 PM, Peter Boughton wrote: > >> >>> 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:3303 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
