Thanx... I wan't paying enough much attention or I would have noticed that Google gave me the 6.1 docs when I searched for CFSQLType
Thanx G! On Sun, Mar 22, 2009 at 7:59 PM, Francois Levesque <[email protected]>wrote: > > Try this for MSSQL: http://www.cfquickdocs.com/cf8/#cfqueryparam. > > I have no idea why MySQL isn't on there, but it should at least get you > started. > > Francois Levesque > http://blog.critical-web.com/ > > > On Sun, Mar 22, 2009 at 7:38 PM, Gerald Guido <[email protected] > >wrote: > > > > > Does anyone have a list of the SQL datatypes for MySQL and MSSQL as they > > are > > related to CfQueryParam cfsqltype when returned by cfdbinfo's TYPE_NAME? > > > > I am building a function to tease those out and want to make sure I get > as > > many as I can matched up correctly. I thought I would ask here before > going > > code spelunking into On Tap, Reactor and Transfer. > > > > It would be nice if cfdbinfo returned that but, unless I am missing > > something obvious, no deal. > > > > BTW I was looking though my archive and I have a bunch of MySQL databases > > with the data type being Enum with either "0,1" or 'yes,no", "true, > false" > > as the values. Seeing that enum can have more than 2 values and can be > text > > values.... how do those work with cfsqltype? > > > > As always, many TIA, > > > > G! > > -- > > Gerald Guido > > http://www.myinternetisbroken.com > > > > > > "To invent, you need a good imagination and a pile of junk." > > -- Thomas A. Edison > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
