Question Title: Insert Multiple Records-Using repeat region (ASP+VBS)

[mrkipling]

I have a page displaying records using a repeat region from tableA. Each repeat region includes two checkboxes and a list box.

I need to insert into tableB a new record with the unique key from each record in TableA and the input from the form components.

I assume I need to assign a unique name to each form component, but need some guidance on this.

TIA.

Mark

 

[Cheech]

Have a look at this method of updating multiple records

http://www.drdev.net/article11.asp

and seeif you can alter it to your requirements

I would just send the form to an asp page and loop through each record inserting it. To get unique form elements just add a counter before your repeat region and name each element like this

<%
dim counter
counter = 1
%>
<% repeat region start %>
<input type="checkbox" name="checkbox<%=counter%>" value="Whatever">
<% counter = counter+1 %>
<%next%>

Cheech

[Peace][Pipe]

 

[mrkipling]

Thanks for your help Cheech,

I have modified the tutorial you have linked to, my form page assigns a unique id to each text box using a variable containing the recordID, I am unsure of how to structure the loop to insert these fields into the DB ?

Thanks