Hello all,
I have the following code:
<cfoutput query = "qGetQuestions">
<TR>
<TH> <div align="left">#Question#</div>
<input type="hidden" value="#Question_ID#"
name="Question_ID">
</TH>
<cfloop list="#Answer_ID#" index="x">
<cfstoredproc procedure="PR_UserGetAnswers"
datasource="#Session.DSN#">
<cfprocparam
cfsqltype="cf_sql_integer" dbvarname="Question_ID" type="in"
value="#Question_ID#">
<cfprocparam
cfsqltype="cf_sql_integer" dbvarname="Answer_ID" type="in" value="#x#">
<cfprocresult name="qGetAnswers">
</cfstoredproc>
<CFLOOP QUERY="qGetAnswers">
<td>
#Answer#
<input
type="hidden" name="Answer_ID" value="#Answer_ID#"><BR>
</td>
</CFLOOP>
</cfloop>
</tr>
</cfoutput>
All works great except for the Answer output. The answers come from a
select list. When the user selects more than one item in the list, then
what I want is for each item to break after the first. That is not
happening. What is happening is that each answer is going into it's own
td cell. I tried using a cfif with a mud function, but it was not
working correctly. Can anyone assist?
TIA,
Bruce
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
