I'll have to talk to you off-list about that... with the system I have I'm not too sure I can at this point. Heading out to run some errands and will be back later this afternoon.
On Sat, Nov 15, 2008 at 2:33 AM, Maureen <[EMAIL PROTECTED]> wrote: > 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:280476 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
