mysql error message on confirm.php
I keep getting an error trying to assign the transaction id and correlation id to the DB. I have narrowed it down to one or both because when I remove them then the page processes with no trouble. the mysql error is
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[OrderTransaction ID],OrderReceiptID,OrderVisitorID,OrderShipping,OrderTax,Order' at line 1"
I am not sure how to fix this. I have included the confirm.php page.
I am also having a problem were my ecart object is set to UKP but the transactions for website payment pro as come through as USD. I read a few other Post and found this
"and change it to:
<input type="hidden" name="currency_code" id="currency_code" value="GBP" />"
to change the hidden field called "currency_code" on the confirm.php. I can not find that hidden field and wondering how I can change this - I am using ecart 5 if this makes a difference.
Many thanks as always for you help