I thought that when I made it the first time :-) Russ
-----Original Message----- From: Rick Colman [mailto:[EMAIL PROTECTED] Sent: 02 January 2006 17:52 To: [EMAIL PROTECTED] Subject: RE: Best Approach for Survey Question This is a very cool approach to doing it. Thank you. -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, January 02, 2006 9:33 AM To: CF-Talk Subject: RE: Best Approach for Survey Question I once made a form build that could be used for pretty much anything, profiles, questionnaires, anything that required a form. It was constructed something like thus:- Table: questions questionID int primarykey Question varchar Fieldtype varchar Required bit default(0) Size int Maxlength int Validation varchar Multiple bit default(0) Table: answers answerID int primarykey questionId int Answer Table: Options optionID int primarykey Optiontext varchar Optionvalue varchar DefaultSelected BIT default(0) So then you just loop over the questions, creating the specifield form field types with the specified attributes. For select lists, multi radios or checkboxes, you just add items to the options table. E.G. <cfquery name="questions"> Select * from questions </cfquery> <cfquery name="options"> Select * from questions </cfquery> <cfloop query="questions"> <cfset QUID = questionID> <cfif fieldtype="select"> <select name="Q#QID#" #IIF(multiple, "'multiple'", "''")# size="#size#"> <cfloop query="options"> <cfif questionID = QID> <option value="#optionvalue#" #IIF(SefaultSelected, "'Selected'","''")#>#optiontext# </cfif> </cfloop> </select> <cfelseif fieldtype is "text"> <input type="text" name="Q#QID#" maxlength="#maxlength#" size="#size#"># </cfif> Get the idea? Then when the form is submitted you simply save the answers in the answers table for the specified QID. -- Russ -----Original Message----- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: 02 January 2006 15:43 To: CF-Talk Subject: RE: Best Approach for Survey Question ALWAYS use separate columns. I've been bit in the a$$ just about every time I tried the comma-delim list approach. Another plus is it's really easy to return an Excel file directly to those doing the tabulating - which they seem to like - without bugging me for the "latest results" 3 times a day. -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Sunday, January 01, 2006 9:14 PM To: CF-Talk Subject: Best Approach for Survey Question I am trying to determine the best way to structure a series of survey questions, keeping in mind that I need to make it easy to use for the respondent, easy to code, and easy to tabulate the data later on. I can structure the following typical question as a single set of checkboxes: Q5: Please select schools that provide interns (check all that apply): [ ] Sciences [ ] Management/Business [ ] Law [ ] Communications [ ] Other Using a single datafield for the question, I then would need to parse a comma-delimited list to separated the answers. - or - I can use a series of radio buttons: Q5:Please select schools that provide interns (check all that apply): A. Sciences [ ] B. Management/Business [ ] C. Law [ ] D. Communications [ ] E. Other [ ] If I use a separate data field (5 in this case) for each sub-part of the question, then it is easy to tabulate results for each part. Recommendations appreciated. Richard Colman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228141 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
