Re: Reactor For CF Enum columns

[Peter J. Farrell]

Doug Hughes said the following on 2/20/2006 9:41 AM: 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 ENUM: <cfqueryparam value="#arguments.companyStatusBean.getCompany_statuscode()#" cfsqltype="cf_sql_varchar" /> You would pass in a single value like "valid" or "suspended". SET: <cfqueryparam value="#arguments.companyStatusBean.getCompany_statuscode()#" cfsqltype="cf_sql_varchar" /> You would pass in a single value like "valid" or multiple values like "valid,confirmed". There shouldn't be a length attribute to the queryparam IMHO because the ENUM or SET values could change and there really isn't any reason to check the length since the DB will match the passed value or values to the list it has internally. http://dev.mysql.com/doc/refman/5.0/en/enum.html http://dev.mysql.com/doc/refman/5.0/en/set.html -- 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/