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