If you're locked into a design and cannot add a table for normalization, you can fake it with a delimited list. I usually use a pipe character as a delimiter instead of a comma so I recognize the data as deliberate and not an accidental write from a form field that somehow gets more than one value,and the pipe character doesn't confuse some SQL parsers like commas do.
This makes the SQL a bit cleaner because you do this: <cfset catvalue = "|" & #categoryid# "|"> select from table where field contains #catvalue# Or, as suggested, you can write a SQL function to parse the list. On Sat, Nov 15, 2008 at 12:55 PM, Erika L. Walker <[EMAIL PROTECTED]> wrote: > I know. I have normalized data before in other stuff I've done... but it's > been a LONG time. My brain is rusty. The Churvii crammed normalization into > my head several times over the years. I had Inner and outer join down so > good, I could do them in my sleep. It's amazing what you forget when you > haven't coded full time in years. > > And yeah, I'd like to kill the database designer myself on this one. :) > > > On Sat, Nov 15, 2008 at 10:54 AM, Deanna Schneider < > [EMAIL PROTECTED]> wrote: > >> You'll save yourself a million hours of headaches if you can normalize >> your data in the way that Maureen is describing. I'm a bit of a >> database design snob, but the the system you have? Man, I'd kill the >> database designer. :) >> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:280484 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
