I had seen that, but that's for MSSQL. Is it definitely the same for MySQL?
Rich On Mar 10, 2010, at 12:46 PM, DK wrote: > > 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" <[email protected]> > To: "sql" <[email protected]> > 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:3302 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
