Most excellent. Just what I was looking for. Thank you sir! G!
On Sun, Mar 22, 2009 at 10:54 PM, Dave Watts <[email protected]> wrote: > > > 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? > > MySQL ENUM columns are variable-length strings, so VARCHAR would be > the corresponding datatype: > > > http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html > > > 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 > > To avoid that in the future, use Google's handy "site" filter: > > "cfsqltype site:livedocs.adobe.com/coldfusion/8" > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
