RE: Reactor For CF Enum columns

[Doug Hughes]

Do me one more favor:   Can you send me what the cfqueryparam would look like for both enum and set?  I want to see how the data is passed in and it’s various attributes.   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter J. Farrell Sent: Monday, February 20, 2006 10:29 AM To: reactor@doughughes.net Subject: Re: Reactor For CF Enum columns   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/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/