thco
Technical User
- Aug 6, 2003
- 10
I need help capturing a query string into a daba base file.
At this time I'm not interested in having the data in a SQL
data base for access or updating there.
Instead, I would simply import and manipulate all the orders into a data base on my
computer.
My test order page is located at:
When a customer submits this order page to
the gateway (Iongate) and the order is processed,
the query string (sample below)
?APPROVALCODE=180466&REPLYCODE=000&RESPONSECODE=AA&AUTHSOURCE=5&CAPCODE=5&AMEXCAPCODE=2&TRANSDATE=012302&TRANSTIME=145850&AVSRESPONSE=Y&AUTHRESPONSE=APPROVAL&CVV2RESPONSE=&AMOUNT=197%2E00&CARDTYPE=VISA&CARDNUM=42XXXXXXXXXX3627&EXPIRES=0202&TYPE=SALE&CARDNAME=Theodore+Smith&ADDRESS=248+240th+Ct+SE&ADDRESS2=&CITY=Seattle&STATE=WA&ZIP=98004&COUNTRY=USA&PHONE=&EMAIL=thansson%40thansson%2Ecom&CUSTNO=&INVOICENO=41&DESCRIPTION=Highly+Confidential+Directory+of+Paper+Buyers&TERMINAL=
is sent to the receipt URL pointing to the perl script at:
(chmod set at 755)
You can see the script at:
The script then sends the following page to the
customer:
What am I missing??? Why isn't this working???
Thanks for any help you can give me on this
Kindly,
Ted
At this time I'm not interested in having the data in a SQL
data base for access or updating there.
Instead, I would simply import and manipulate all the orders into a data base on my
computer.
My test order page is located at:
When a customer submits this order page to
the gateway (Iongate) and the order is processed,
the query string (sample below)
?APPROVALCODE=180466&REPLYCODE=000&RESPONSECODE=AA&AUTHSOURCE=5&CAPCODE=5&AMEXCAPCODE=2&TRANSDATE=012302&TRANSTIME=145850&AVSRESPONSE=Y&AUTHRESPONSE=APPROVAL&CVV2RESPONSE=&AMOUNT=197%2E00&CARDTYPE=VISA&CARDNUM=42XXXXXXXXXX3627&EXPIRES=0202&TYPE=SALE&CARDNAME=Theodore+Smith&ADDRESS=248+240th+Ct+SE&ADDRESS2=&CITY=Seattle&STATE=WA&ZIP=98004&COUNTRY=USA&PHONE=&EMAIL=thansson%40thansson%2Ecom&CUSTNO=&INVOICENO=41&DESCRIPTION=Highly+Confidential+Directory+of+Paper+Buyers&TERMINAL=
is sent to the receipt URL pointing to the perl script at:
(chmod set at 755)
You can see the script at:
The script then sends the following page to the
customer:
What am I missing??? Why isn't this working???
Thanks for any help you can give me on this
Kindly,
Ted