Thanks. Will do. Also found this, although I don't see the comment this person refers to:
http://gavin.mclelland.ca/2008/06/13/26/ Thanks again, Rich On Mar 10, 2010, at 12:20 PM, Ray Thompson wrote: > > Char is generally fixed length although will probably work just > fine. I > don't know what CLOB is as I have never used it. LongVarChar I have > also not > used. I do know that varchar will probably work just fine. I use it > for all > my text fields regardless of how they are defined in the DB (char or > varchar > in SQL 2005). > > Ray Thompson > Tau Beta Pi - www.tbp.org > The Engineering Honor Society > 865-546-4578 > > >> -----Original Message----- >> From: Rich [mailto:[email protected]] >> Sent: Wednesday, March 10, 2010 12:11 PM >> To: sql >> Subject: Re: cfqueryparam and MySQL text field >> >> >> 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:[email protected]] >>>> 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:3296 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
