Solved

Submit from list

Posted on 2009-04-03
4
141 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
  • 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now