Thanks for the insight Patrick. What I am attempting to do is get this classifieds application going, and then I would like to be able to design an auction system off the same application with very few changes. I believe you are on the right track though and now the only problem is the implementation. I will of course be mulling this all over and trying to decide on the right way. Another idea I was having is that the only categories that are truly different from others is Automobiles, Real Estate and Help Wanted. I think that everything else that a person might want to advertise is just general in nature. Maybe that will help me in my task at hand.
Regards, Doug B. ----- Original Message ----- From: "Patrick McElhaney" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Friday, November 24, 2006 7:44 PM Subject: Re: Design question (Database etc) > Now that I've answered your question, let me throw in an opinion. If > you're building a generic classified system, you might be better off > with category, description and maybe a couple fields for contact > information. That seems to have worked for craigslist. > > Patrick > > > On 11/24/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > 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:261643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4