You could loop the list and add a new table that was for BusinessCategory with the following structure: businessCategoryID / businessID / categoryID
then just find the businesses that have a categoryID Rob On Sat, Nov 15, 2008 at 12:35 AM, 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:280461 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
