RE: DB normalization rules and multi-select

2000-07-07 Thread Philip Arnold - ASP
1. Create a list of current categories assigned to the locale 2. query all the categories 3. output the query, and select the category if its in the list cfoutput query="GetCategories" cfif CurrentCategories contains GetCategories.Category_ID option value="#Category_ID#"

RE: DB normalization rules and multi-select

2000-07-05 Thread Matt Rodosky
1. Create a list of current categories assigned to the locale 2. query all the categories 3. output the query, and select the category if its in the list cfoutput query="GetCategories" cfif CurrentCategories contains GetCategories.Category_ID option value="#Category_ID#"

RE: DB normalization rules and multi-select

2000-07-05 Thread Perez, Bismark
Thanks Matt and Jesse, I'll try your approach... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a