Shopping cart to a databse.

[twinuno]

I saw a recent post where you sent that shoping cart, i have found one very similiar but the only problem i have is writing what i purchased as well at the customer info for the data base. My site is for my experience only. http://ec.scranton.edu/lentinia/EC46...t/template.asp. If you could look at the shopping cart for me.
I need to figure out how to write this form to a database, there are two files.

http://ec.scranton.edu/lentinia/checkout.htm
http://ec.scranton.edu/lentinia/thankyou.htm

[Smokie]

Here is the code to do a database insert, of course you need to create a database first if you havent got one already...

Code: Select all

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("data.mdb") & ";"
 
strName = Request.Form("Name")
 
strQuery = "INSERT INTO tblPeople ([Name]) VALUES ('"&strName&"')"
 
Set objRS = objConn.Execute(strQuery)
Set objRS = Nothing
 
objConn.Close
Set objConn = Nothing

[twinuno]

ive gotten that far, but i cant write what the user has bought to the database how do i do about doing that.