Hi

I'm using jquery to pass trough data to another page where I want to insert and delete a record. But the problem is that jquery only inserts or deletes the records and not both together.

I use following code:

For jquery:

2. $(document).ready(function(){
3. $("#btnAddPayment").click(payment);
4. });
5. 
   
6. 
   
7. //example 1
8. function payment(){
9. 
   
10. $.ajax({
11. type:"POST",
12. url: "acceptPaymentExecute.asp",
13. dataType: "application/x-www-form-urlencoded",
14. data: "amount=" + $("#amount").val() + "&reason=" + $("#reason").val() + "&bookingDate=" + $("#bookingDate").val() + "&accountNumber=" + $("#accountNumber").val() + "&memberID=" + $("#memberID").val() + "&memberPaymentID=" + $("#memberPaymentID").val(),
15. success: function(msg){ $("#fldPayment").append(msg);}
16. })
17. }

In my acceptPaymentExecute.asp page:

2. amount = Request("amount")
3. bookingdate = Request("bookingDate")
4. reason = Request("reason")
5. accountNumber = Request("accountNumber")
6. memberID = Request("memberID")
7. memberPaymentID = Request("memberPaymentID")
8. 
   
9. set objConn = Server.CreateObject("ADODB.Connection")
10. set objRS = Server.CreateObject("ADODB.Recordset")
12. objConn.open conn
13. 
    
14. yearDate = Year(bookingdate)
15. bookDate = Year(bookingdate) & "-" & Month(bookingdate) & "-" & Day(bookingdate)
16. 
    
17. strInsertPayment = "INSERT INTO payment(memberID,amount,bookingdate,reasonPayment,paymentYear,accountNumber) VALUES (" & memberID & "," & amount & ",'" & bookDate & "','" & reason & "'," & yearDate & "," & accountNumber & ");"
18. strDeleteMemberPayment = "DELETE FROM memberPayment WHERE memberPaymentID = " & memberPaymentID & ";"
19. 
    
20. objRS = objConn.execute(strInsertPayment)
21. objRS = objConn.execute(strDeleteMemberPayment)
22. 
    
23. objRS.close()
24. set objRS = nothing
25. objConn.close()
26. set objConn = nothing

The queries work but not together. If I comment the insert statement, my page executes the delete statement, ...

I already tried to call another object for my delete statement but it does the same.

Can somebody help me with this problem?