Error in Paypal IPN When Using Onepage Checkout Together With Other Payment Gateway

In VPASP version 7.00, if you are using onepage checkout together with other gateway, and with Paypal IPN as the payment gateway, if you get this error during checkout :

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'orderid='.
/paypalipngateway.asp, line 72

You will need to tweak your Paypal IPN files:

1. Please open file paypalipngateway.asp using notepad or text editor.

2. Locate this code :

strsql = "select * from orders where orderid=" & oid

3. Before that line, please insert this new code :

dim oid
oid=GetSess("oid")
If oid="" then
shoperror getlang("langSessionlost")
end if

4. Save the file and upload to your site.

5. Open file paypalipnconfig.asp using notepad or text editor.

6. Locate this code :

'const CommaAsDecimal="No"

7. Please replace to (by removing the ' in front of the line) :

const CommaAsDecimal="No"

8. Save the file and upload to your site.

---