I can tell you what we have done when faced with a similar problem, maybe it will help you out. We create a table that holds the question, client id, and field type (select, numeric, text, etc.). There is another table that will store the values if a field is select type, we call this the lookup table. We store the answers to the questions in four seperate tables (text, varchar, int, and datetime) with a questionid, the person's id that is filling out the form, and the answer. Each of those tables stores the answer determined by the type of field that is being rendered. Our system is actually quite a bit more complex that what I have described here, but these are the basics of what we do. Hope it helps.
On 6/23/07, Eric J. Hoffman <[EMAIL PROTECTED]> wrote: > > We have an app, and differing clients are layering on top of the system, > and each would like a few custom questions asked. > > > > So, I am faced with creating this and am wondering if anyone had some > experience they can share. Basically create an add-on to allow custom > fields. > > > > I created a client table so we can track which clients are active with > custom fields; then another table that says what the clientID is and a > row for custom field names. > > > > Now I am stuck. So am I going in the right direction...another table > with the data input with the ID of the custom field name and the value > input in the form, dunno....but I am confused as how do I notate INT, > nvarchar, any length limits, etc. Guess I am wondering how folks > approach this scenario.... > > > > Thanks. > > -------------------------------------------------------- > > > Eric J. Hoffman > Managing Partner > 1940 Greeley Street South > Suite 102 > StillwaterMN55082 > mail: [EMAIL PROTECTED] > www: http://www.ejhassociates.com > tel: 651.717.4105 > fax: 651.717.4101 > mob: 651.245.2717 > Adobe Solutions Partner > Microsoft Certified Partner > > -------------------------------------------------------- > > This message contains confidential information and is intended only for > [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you > should not disseminate, distribute or copy this e-mail. Please notify > [EMAIL PROTECTED] immediately by e-mail if you have received this > e-mail by mistake and delete this e-mail from your system. E-mail > transmission cannot be guaranteed to be secure or error-free as information > could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, > or contain viruses. Eric J. Hoffman therefore does not accept liability for > any errors or omissions in the contents of this message, which arise as a > result of e-mail transmission. If verification is required please request a > hard-copy version. > -------------------------------------------------------- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
