You have a many to many relationship between the businesses and categories so you need a relational table between them.
Real simple - just two fields table name: business_to_category businessid - foreign key to the business table id categoryid - foreign key to the category table id I have the code to both write and read the data for the check boxes using this method if you want it. On Fri, Nov 14, 2008 at 9:35 PM, Erika L. Walker <[EMAIL PROTECTED]> wrote: > 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:280465 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
