But this doesn't help in storing multiple categories per site. Unless you store multiple cat IDs in the Cat column but this will be nothing but painful when getting at the data.
Adrian > -----Original Message----- > From: Paul Kukiel [mailto:[email protected]] > Sent: 12 August 2009 11:44 > To: cf-newbie > Subject: Re: write multiple category to DB > > > Generally I would break this up into 2 tables: > > Record table: > > record_id, catagoryid, Text, URL, Disc, Cat > > Category table: > catagoryId, catagoryName, catagoryDescription > > but you could also just make category a column on the record table: > > record_id, Text, URL, Disc, Cat, Catagory > > > Paul. > > On Aug 11, 2009, at 10:33 PM, John Barrett wrote: > > > > > Hi, > > I am working on a List admin that has a form that write URLs with > > data to a db. I am confused on how can I add the category to > > multiple area. > > I have a form that writes to a DB: > > The database has > > 1) Site name > > 2) url > > 3) paragraph about what the site includes > > 4) Topic areas to place the site. Most urls will go in multiple > areas. > > > > This is done for one category. Okay maybe having 30 different > > versions of the same add/delete/update form is not good practice, > > but I am new at this. > > > > So for example I would have Adobe(http://adobe.com), and a > > description about adobe. But I would place adobe in many categories, > > such as ColdFusion, Flash, Flex, etc. > > > > So if I have a table for each page that I want to update, I have 30 > > so far, how can I write to multiple tables at the same time? > > > > The DB structure is: > > record_id, Text, URL, Disc, Cat > > > > Any help would be great, > > Thanks so much, > > John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4694 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
