Thanks to Jim Wright for the answer. I had completely blanked on being able to
use a nested <cfoutput group> with an outer query output grouping.
<cfoutput query="getAdditionalQuestions" group="questionID">
<cfoutput group="answersetid"><br />
#answersetname#<br />
<cfselect name="Q_question#ctr#">
<cfoutput>
<option value="#questionID#_#answerID#">#answername#</option>
</cfoutput>
</cfselect>
</cfoutput>
</cfoutput>
Thanks for the suggestions from everyone, including the disrupted one!
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274849
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4