Is there supposed to be a choice? Isn't there one that's "supposed to be used" for text?
Thanks, Rich On Mar 10, 2010, at 8:16 AM, Ray Thompson wrote: > > 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:3291 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
