Re: Reactor For CF Enum columns

[Peter J. Farrell]

Doug Hughes said the following on 2/20/2006 9:22 AM: So… I give up.  I’m really not a MySQL guru.  What the heck is an enum column?  What would the datatype be mapped to in CF?     Doug Enumerated list (ENUM).  I could set ENUM('valid','invalid'archived','cleanup') for the column.  The column would only take on of those values.  It would map to a string in ColdFusion - probably cf_sql_varchar or cf_sql_char if forced to. ENUM is way different from a SET type column.  I could set the column to SET('valid','invalid'archived','cleanup') for the column.  The column could take any combination of those values via a comma list.  It would map to a string in ColdFusion - probably cf_sql_varchar or cf_sql_char if forced to. ENUM takes one value and SET takes one or more values -- of course there is always NULL. .Peter -- Peter J. Farrell :: Maestro Publishing Member Team Mach-II :: Member Team Fusion http://blog.maestropublishing.com Create boilerplate beans and transfer objects for ColdFusion! Fire up a cup of Rooibos! http://rooibos.maestropublishing.com/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/