Guest hodgey87 Posted March 26, 2009 Share Posted March 26, 2009 morning all,just wondered if anyone could help,i currently have a payment page where there is a form to fill out for payment details, this gets passed to the payments page where it is all inserted into the database.i can get this information into the database fine, but now i need to add the paymentid to an order table. This is what i have so far: Session("paymentid") = PaymentIDPaymentID = Session("paymentid")cartID = Session("cartid")Dim strSQL strSQL = "insert into [Order] ([OrderDate], CartID, PaymentID) " _& " VALUES (" & DATE() & "," & cartid & "," & paymentid & ")"Response.Write strSQLConn.Execute strSQL i get:insert into [Order] ([OrderDate], CartID, PaymentID) VALUES (3/26/2009,112,) just missing the paymentidcan anyone helpthanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.