I have a form that is using a cfloop query to produce a input field for
productid quantity. It can produce several input fields depending on the query.
Example -
<td><input type=text size=3 name="QTY_<cfoutput>#prodid#</cfoutput>"></td>
In the submit processing page I need to take the productid's that have a value
to insert into the database.
I have created a list (Plist) from the form submitted,
Plist===QTY_101,QTY_102,QTY_103
Then I loop through to take out only the fields that have a value, <cfloop
list="#plist#" index="z">
<cfif evaluate("form.qty_#z#") GTE 1>
<cfoutput>#z#-#evaluate("form.qty_#z#")# <br /></cfoutput>
<cfset zlist = #evaluate("form.qty_#z#")#>
<cfset zlist = ListAppend(zlist, "#z#")>
</cfif>
</cfloop>
The problem I am having is how do I make a list so when i do the update query I
can insert the product id and the quantity.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316272
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4