inserting info in database using subroutine

[cic]

created a site that allows a user to purchase as many books as the want. after they order a book i would like to input their information into a database. i was told to use a procedure or a subroutine to do this, but i am not sure i fully understand how to go about doing this.

this is what i have started:

Sub insertDBinfo
SQL = "INSERT INTO publicationNW
(date,publication,quantity,price,freight,total,cardnumber,ag
entnumber,lastname,firstname,birthmonth,birthdate,birthyear,
address,state,zip) values (" &_
+ "getdate(),"&_
+ "'" & Desc1 & "',"&_
+ "'" & qty1 & "',"&_
+ "'" & request.form("price&quot & "',"&_
+ "'" & request.form("freight&quot & "',"&_
+ "'" & total1 & "',"&_
+ "'" & right(request.form("cardNum&quot,4) & "',"&_
+ "'" & request.form("agentnum&quot & "',"&_
+ "'" & request.form("lastname&quot & "',"&_
+ "'" & request.form("firstname&quot & "',"&_
+ "'" & request.form("DOBmonth&quot & "',"&_
+ "'" & request.form("DOBday&quot & "',"&_
+ "'" & request.form("DOByear&quot & "',"&_
+ "'" & request.form("address&quot & "',"&_
+ "'" & request.form("state&quot & "',"&_
+ "'" & request.form("zip&quot& "')"

oConn.execute SQL, ,adExecuteNoRecords
End Sub

desc1 is a book but how do i go about inserting the rest of the books without writing a subroutine for each one.

 

[palbano]

Yeah, you have to do a INSERT INTO for each record you want to add to a table. That's how databases work.

There are bulk operations but they are not relevant to your post.

-pete