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. :)
On Sat, Nov 15, 2008 at 9:41 AM, Erika L. Walker wrote: > 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 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:280477 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
