Doug, Just a suggestion, but, if you need have multiple categories per item, maybe instead add a category and secondary category column to the advertisements table and then just manage each as a delimited list.
On your form, if you keep the names of the form selects the same and your FORM struct will create the value list. Then use DOM scripting to add/remove selects as needed. To retrieve in the public interface you can then retrieve with something like "WHERE #url.category# IN advertisements.category" Regards, Jon On Nov 24, 2006, at 7:25 PM, Doug Brown wrote: > Maybe some clarification is in order. Once the form submits, it all > goes > into a advertisements table. In order to have hundreds of different > fields > for different categories, I would have to have hundreds of > different columns > in the table. I hope I am thinking right. Too much turkey...Makes > you brain > dead. > > > > ----- Original Message ----- > From: "Doug Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Friday, November 24, 2006 5:17 PM > Subject: Design question (Database etc) > > >> I am in the process of re-designing a classifieds system and was just > wondering a few things. Currently there is just one standard for to > fill out > for the ads. I am thinking of designing it to where it is more > useful. I > would like to make the form as dynamic as possible by having different > inputs for different categories of items. The thing is, that I > would imagine > I would need to have a databse table for each category. Am I > correct in this > assumption? Building the forms would be the easy part, but having > say 50 > different tables of info for all categories would be a nightmare. Any > suggestion would be appreciated. >> >> IE: >> >> [Real Estate Form] >> >> Price >> Bedrooms >> Bathrooms >> Garage >> Sq. Ft. >> Acreage >> Covenants >> etc. etc. >> >> [Auto Form] >> >> Make >> Model >> Year >> Miles >> etc. etc. >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
