How able just have a dynamic form builder table for your different forms (formID, Formname) A table for your formfields (formfieldID, fieldname, fieldtype, size, maxlength, required) And a table containing the formfields for each form. (formID, formfieldID) And a table containing the data (FORMID, formfieldID, answer)
Then you can build your form dynamically from this data. Russ -----Original Message----- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 25 November 2006 02:02 To: CF-Talk Subject: Re: Design question (Database etc) Jon, I think I may have confused the subject. In the ad posting, a user fills out the form to place a classified ad and every form is the same no matter what the category is. What I want to do is have different types of forms for different types of categories. Each category would have it's own specific data set. I am using one table to hold all the "advertisements" and I can only think that I would have to use this one table to hold all the different form variables for each category. I was just hoping that there may be a simpler way. Still need some insight. Doug ----- Original Message ----- From: "Jon Clausen" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, November 24, 2006 6:06 PM Subject: Re: Design question (Database etc) > 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:261645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
