>Couldn't you add a Quanity box for the entry? And then loop through that? > ><cfif FORM.Quantity GT 1> ><cfloop from="1" to="#FORM.Quantity#"> > > YOUR DB INSERT HERE > ></cfloop> ></cfif> > >That may be easy.... > >- Nick
That was my first thought. Here is the code: <cfif FORM.Quantity GT 1> <cfloop from="1" to="#form.quantity#"> <CFquery dataSource="laptoprequest"> Insert into hamcom05 ([number],donor,address,city,state,zip,description,[value],purchased,prereg,grand) values(#number#,'#donor#','#address#','#city#','#state#','#zip#','#description#','#value#','#purchased#','#prereg#','#grand#') </CFQUERY> </cfloop> </cfif> I get a attribute validatio error because I don't believe you can loop over an insert query, can you? Or should the CFIF statment fix that? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2741 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
