IPN is now disabled Need help deciphering the asp code

bearwires

New Member
Paypal has been sending emails warning IPN is failing. I've not made any changes to my code, and it is really old code.... has been working for 5+ years.... been so long that I've had to do anything on this site.I searched the server logs for more information... this is what I found repeatedly\[code\]|35|80040e14|Syntax_error_(missing_operator)_in_query_expression_'OrderID='.\[/code\]I checked the code on the ipn page of the site, and I'm stumped.Nothing is changed but it stopped workingThis is line 34 thru 36 of the code of the ipn page:\[code\]MM_Cmd.CommandText = "UPDATE Orders SET txn_id='" & txn_id & "',payment_status='" & payment_status & "' WHERE OrderID=" & Item_numberMM_Cmd.Execute end function%>\[/code\]
 
Top