I'll work on this tonight and see how I fare. I may be back! Thanks for all the help and suggestions. You guys are great as usual! :)
On Sat, Nov 15, 2008 at 4:07 PM, Maureen <[EMAIL PROTECTED]> wrote: > 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:280487 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
