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:320806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
