Thanks. Rich
On Mar 10, 2010, at 12:31 PM, Debbie Morris wrote: > > This page in the MySQL documentation might be helpful: > http://dev.mysql.com/doc/refman/5.0/en/blob.html > > According to it, "...Similarly, you can regard a TEXT column as a > VARCHAR column." > > Debbie > > > -----Original Message----- > From: Rich [mailto:ri...@twcny.rr.com] > 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: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:3300 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
