for text & ntext fields use CF_SQL_LONGVARCHAR see: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_18.html
----- Original Message ----- From: "Rich" <ri...@twcny.rr.com> To: "sql" <sql@houseoffusion.com> Sent: Wednesday, March 10, 2010 12:19 PM Subject: Re: cfqueryparam and MySQL text field > > text > > That's why I'm asking...there is no cf_sql_text. > > > > > On Mar 10, 2010, at 12:16 PM, Peter Boughton wrote: > >> >> What's the type of the field in MySQL? >> >> If it's varchar, use cf_sql_varchar >> if it's clob, use cf_sql_clob >> etc >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3299 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
