When a business edits their profile, they have the option of choosing more than one category via a checkbox. The checkbox value is an ID number correlating to the category. How else would I store that?
On Sat, Nov 15, 2008 at 12:29 AM, Zaphod Beeblebrox < [EMAIL PROTECTED]> wrote: > sql doesn't deal well with lists in columns. You will probably have > to read that in with a cfquery, parse the list inside the column and > then loop through it using more cfquery tags. > > Any chance you could normalize that data? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:280458 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
