Looping... can help to check for it?

[choohean]

I try to do something looping so that I can get a few of records to store in my database with multirow table...

Can anyone here please help check for it!?

This is my code:

dim number, counter

counter = 0

number=Request.Form("count&quot

Do until counter = number
counter = counter + 1

yr = Request.Form("yr_"&counter&"&quot

Response.Write(yr)

Loop

 

[Mighty]

The following code will insert rows containing one field into your database.


dim conn
Set conn = Server.CreateObject("ADODB.Connection&quot
conn.open "DSN=myDB"

dim number, counter, sql

counter = 0

number=Request.Form("count&quot

Do until counter = number
counter = counter + 1

sql = "INSERT INTO myTable (myYear) VALUES '" & Request.Form("yr_"&counter&"&quot & "'"
conn.Execute sql

Loop

conn.close : set conn = nothing Mighty