CF_SQL_VARCHAR would be my first choice. Ray Thompson Tau Beta Pi - www.tbp.org The Engineering Honor Society 865-546-4578
> -----Original Message----- > From: Rich [mailto:ri...@twcny.rr.com] > Sent: Wednesday, March 10, 2010 1:42 AM > To: sql > Subject: cfqueryparam and MySQL text field > > > Hi. Anybody know what the CFSQLType parameter should be in > cfqueryparam when dealing with a text field in a MySQL database? > There is no "CF_SQL _Text". The only ones that seem related are: > > CF_SQL_CHAR > CF_SQL_CLOB > CF_SQL_LONGVARCHAR > CF_SQL_VARCHAR > > Thanks, > > Rich > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3290 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
