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