Solved

Submit from list

Posted on 2009-04-03
4
175 Views
Last Modified: 2013-12-24
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>
0
Comment
Question by:usky1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
gdemaria earned 350 total points
ID: 24059365
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
 
LVL 39

Expert Comment

by:gdemaria
ID: 24059370
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
 

Author Comment

by:usky1
ID: 24060612
That worked great.
0
 

Author Closing Comment

by:usky1
ID: 31566220
Thanks for the quick reply and solution.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to Eclipse 16 154
IIS Site Configuration Copy 2 87
Website URL redirection 10 83
Setting Up Local Lan Web Server 1 99
A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
What You Need to Know when Searching for a Webhost Provider

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question