>use distinct in there to only output one of each name > > I tried distinct, didn't work. Here's what my output looks like:
http://wtomlinson.com/questionCap.jpg SELECT DISTINCT tblquestionsets.questionsetid, tblquestionsets.questionsetname, tblquestions.questionid, tblquestions.questionsetid, tblquestions.question, tblquestions.questioncatid, tblquestions.questionsortnum, tblquestions.questionrequired, tblquestioncats.questioncatid, tblquestioncats.questioncatname, tblquestionsanswers_x.questionanswersetid, tblquestionsanswers_x.answersetid, tblquestionsanswers_x.questionid, tblanswersets.answersetid, tblanswersets.answersetname, tblanswersets.answersettypeid, tblanswersets.answersetrequired, tblanswersettypes.answersettypeid, tblanswersettypes.answersettypename, tblanswersetsanswers_x.answersetsanswersid, tblanswersetsanswers_x.answersetid, tblanswersetsanswers_x.answerid, tblanswers.answerid, tblanswers.answername, tblanswers.answervalue, tblanswers.answersortnum, tblquestionsets.questionsetdateadded FROM tblquestionsets, tblquestions, tblanswersets, tblquestionsanswers_x, tblanswersettypes, tblanswers, tblanswersetsanswers_x, tblquestioncats WHERE tblquestionsets.questionsetID = tblquestions.questionsetID AND tblquestions.questionid = tblquestionsanswers_x.questionid AND tblquestionsanswers_x.answersetid = tblanswersets.answersetid AND tblanswersets.answersetid = tblanswersetsanswers_x.answersetid AND tblanswersetsanswers_x.answerid = tblanswers.answerid AND tblanswersets.answersettypeid = tblanswersettypes.answersettypeid AND tblquestions.questioncatid = tblquestioncats.questioncatid AND tblquestionsets.questionsetID = 1 AND tblquestions.questioncatid = 3 ORDER BY tblquestions.questionid, tblanswersets.answersetid, tblanswers.answerid <cfoutput> #answersetname#<br /> <cfselect name="Q_question#ctr#"> <cfoutput> <option value="#questionID#_#answerID#">#answername#</option> </cfoutput> </cfselect> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
