Thanks for the responses so far...a few different methods but with the same core principle it seems....I guess doing this the first time is a bear and its probably simple once you get through it.
-------------------------------------------------------- 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 [email protected] 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. -------------------------------------------------------- -----Original Message----- From: Tanjible Developer [mailto:[EMAIL PROTECTED] Sent: Sunday, June 24, 2007 1:47 PM To: CF-Talk Subject: Re: How to architect question: custom fields 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 [email protected] 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. > -------------------------------------------------------- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
