I am trying to add multiple records to the same table in my database. I know how to enter one recordset to my database at a time, but how do I enter multiple recordsets to the same db table. Here is what i have so far. Can anyone tell me what I am doing wrong?
------------------------
test.asp
------------------------
<form name = "form" form method="POST" action="test2.asp">
<p><input type="text" name="varname" size="20"><input type="text" name="varid" size="20"></p>
<p><input type="text" name="date1" size="20"><input type="text" name="value1" size="20"><input type="text" name="notes1" size="20"></p>
<p><input type="text" name="date2" size="20"><input type="text" name="value2" size="20"><input type="text" name="notes2" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
---------------------------
test2.asp
---------------------------
DIM adoCon, mySQL
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Provider="Microsoft.Jet.OLEDB.4.0"
adoCon.Open "c:\inetpub\wwwroot\cworkman\testing\GAFKPM.mdb"
FOR i = 1 to 2
IF Request.Form(" Value" & i) > " " THEN
mySQL = " INSERT INTO Val (varid, date, value, notes) VALUES"
mySQL = mySQL & " (#" & Request.Form(" varid" ) & " #, #" & Request.Form(" date" & i) & " #, #" & Request.Form(" value" & i) & " #, #" & Request.Form(" notes" & i) & " #)"
Response.write(mySQL)
adoCon.execute(mySQL)
END IF
NEXT
adoCon.close
set adoCon=nothing
Topic Options
Post Options
Thanks(0)
