Submit from list

I have a loop query that I need to submit the value from the selected value.
For example if the query comes back with 20 rows of information and I select the 5 row. it always gives me the result from the first row. How can I get it to supply the customer_no for the the one I selected?
<table border=0>
      <cfloop query="getSupplies">
            <cfoutput>
                  <tr>
                  <td height="24"><input name="customer_no" value="Continue" type="submit">#getSupplies.customer_no# - #getSupplies.ship_to# - #getSupplies.scity# - #getSupplies.sstate#</a></td>
                  </tr>
            <input type=hidden name="customer_no" value="#getSupplies.customer_no#">
            </cfoutput>
      </cfloop>
</table>
usky1Asked:
Who is Participating?
 
gdemariaConnect With a Mentor Commented:
use javascript to assign the value of the selected button before submitting
<table border="0">
<cfloop query="getSupplies">
 <cfoutput>
  <tr>
	<td height="24">
	   <input name="customer_no" value="Continue" type="submit" onClick="documents.getElementById('custNo').value='#getSupplies.customer_no#'">
       #getSupplies.customer_no# - #getSupplies.ship_to# - #getSupplies.scity# - #getSupplies.sstate#
	</td>
  </tr>
</cfoutput>
</cfloop>
</table>
<input type="hidden" id="custNo" name="customer_no" value="">

Open in new window

0
 
gdemariaCommented:
notice there is only one customer_no field, a hidden one, outside of the loop

when you click the submit, the value gets assigned into that field and submitted
0
 
usky1Author Commented:
That worked great.
0
 
usky1Author Commented:
Thanks for the quick reply and solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.