What I would do is when you display the items on the
page awaiting input value for ordering,
use: <input name="quantity#ID#" type="text" size="8">
Then on your action page Loop through your
query and use:
<cfloop query="getitems">
<cfif IsDefined("quantity" & Product_ID) IS "YES">
<cfset Order_value = #Evaluate("quantity" &
Product_ID)#>
<cfif order_value NEQ "" AND order_value GT 0>
THIS IS A VALID ORDER ---
OUTPUT ITEM NAME, ETC
</cfif>
</cfif>
</cfloop>
>>> [EMAIL PROTECTED] 10/21/02 01:58PM >>>
OK. I see now. Am indeed getting a LOT of output. This is showing every
product by number, then every description. What I want/intend to have
show is only those product numbers and descriptions that correspond with
an order being made. That is, on the order form, (which appears in
rows), the visitor enters a number next to a product, and that is what
is passed (along with any other products ordered) to the results page.
Instead, I'm getting them all. I know what I am doing wrong but don't
know what to do to be right...what is wrong is that each row has a field
'ItemID', 'Description', and 'quantity' (this is the text box). These
appear on the order form and the data is dynamically displayed. I know
that the problem is that each product doesn't have a unique field name.
But not sure how to display all these on the order page then assign each
an individual id that would be passed to the results. Does that make
sense? What I mean, is that I need to display all the products on t!
he order form, but do I/how do I only pass along those which have an
order placed in the text box?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
