I saw a bunch of responses, and I don't think I have much else to add except that one of the chapters of the Instant ColdFusion book discusses this. ( Yes, I wrote it, so that is self-promotion ) ..
I believe that it goes something like this: Answers (AnswerID, Answer) Questions (QuestionID, Question) QuestionAnswers(QuestionID, AnswerID, total ) When someone answers the question, with an answer, you just update the QuestionAnswers table. At 09:03 AM 4/15/2002 -0400, you wrote: >I am having trouble creating a 'simple' survey with answers like the >following: > >'Strongly Agree' >'Agree' >'Neutral' >'Disagree' >'Strongly Disagree' > >I cannot conceptualize how to store and make sense of the answers without a >huge amount of code. We do not care to record individual answers (but >will/can), but want to know how many people agree/disagree with each >question. (There are 10 questions.) All the questions have the same >possible answers. > >Any help is greatly appreciated, > >Craig Thomas >www.worldcupbicycles.com > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
