[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Submit from list

Posted on 2009-04-03
4
Medium Priority
?
190 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 1400 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

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

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

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

650 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