CFLoop and inputting values

it has been many many years since have used cf, rusty!

 

i have standard form, has approx 10 rows of data.  know can use cfloop insert data, question before go ahead , is...........

 

how loop based on number of rows in form, can't remember.

 

here insert.

 

<cfloop

<cfquery name="new_item" datasource="prouddb">

insert s_venue_stock

(venue,

item,

opening_balance,

stock_in,

stock_out

)

values (

#form.venueid#,

#form.itemid#,

#form.openbal#,

#form.stockin#,

#form.stockout#             

)

</cfquery>

its ok ive worked out now............i rusty!

More discussions in ColdFusion

adobe