RE: Reactor For CF Enum columns

[Michael Lantz]

I believe it is referring to "ENUMERATED TYPES".  I am not sure why they would have a datatype for this, as all it is is a string.  It should work the same as a "varchar" though.   Michael From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Monday, February 20, 2006 8:23 AM To: reactor@doughughes.net Subject: RE: Reactor For CF Enum columns 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   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Blackwell Sent: Monday, February 20, 2006 9:58 AM To: reactor@doughughes.net Subject: Reactor For CF Enum columns   Hi all,   I seem to get an error when creating a record for a table that has an Enum column.  I’m using MySQL 5.  If I look in at the ObjectDAO for mysql the getCfDataType() function returns “string” for enum, but the getCfSqlType() doesn’t have an entry for enum, should it not return “cf_sql_varchar”?  Would validating the value of an Enum column be something that reactor might want to do?   Also in the getCfSqlType() function for mysql and mysql4 there is a typo.                                <cfcase value="double,double percision"> Should be                              <cfcase value="double,double precision">       Cheers,   Chris   -- 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/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/