Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Anyone used PayPal IPN?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts
Posted - 08 February 2004 :  12:27:36  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I have a site that I have the PayPal IPN working fine on. The only problem I am having is that I did not know what to set the database fields at for each field. I basically have everything set at nvarchar(50) in SQL. Here is a list of all the different forum fields I found out that "could" get sent thru

Receiver_Email = Request.Form("receiver_email")
Receiver_ID = Request.Form("receiver_id")
Business = Request.Form("business")
Item_Name = Request.Form("item_name")
Item_Number = Request.Form("item_number")
Quantity = Request.Form("quantity")
Invoice = Request.Form("invoice")
Custom = Request.Form("custom")
Option_Name1 = Request.Form("option_name1")
Option_Selection1 = Request.Form("option_selection1")
Option_Name2 = Request.Form("option_name2")
Option_Selection2 = Request.Form("option_selection2")
Num_Cart_Items = Request.Form("num_cart_items")
Payment_Status = Request.Form("payment_status")
Pending_Reason = Request.Form("pending_reason")
Payment_Date = Request.Form("payment_date")
Settle_Amount = Request.Form("settle_amount")
Settle_Currency = Request.Form("settle_currency")
Exchange_Rate = Request.Form("exchange_rate")
Payment_Gross = Request.Form("payment_gross")
Payment_Fee = Request.Form("payment_fee")
Mc_Gross = Request.Form("mc_gross")
Mc_Fee = Request.Form("mc_fee")
Mc_Currency = Request.Form("mc_currency")
Tax = Request.Form("tax")
Txn_Id = Request.Form("txn_id")
Txn_Type = Request.Form("txn_type")
Reason_Code = Request.Form("reason_code")
Memo = Request.Form("memo")
First_Name = Request.Form("first_name")
Last_Name = Request.Form("last_name")
Address_Street = Request.Form("address_street")
Address_City = Request.Form("address_city")
Address_State = Request.Form("address_state")
Address_Zip = Request.Form("address_zip")
Address_Country = Request.Form("address_country")
Address_Status = Request.Form("address_status")
Payer_Email = Request.Form("payer_email")
Payer_Id = Request.Form("payer_id")
Payer_Status = Request.Form("payer_status")
Payment_Type = Request.Form("payment_type")
Notify_Version = Request.Form("notify_version")
Verify_Sign = Request.Form("verify_sign")
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 08 February 2004 :  14:34:46  Show Profile  Visit HuwR's Homepage
the paypal ipn guide should give you an idea of how to set up your db fields, as it gives examples of the field contents.

Drop me an email if you need help, I have set up a few sites to use paypal's IPN
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 08 February 2004 :  15:05:31  Show Profile
I want to use this service, the only issue is that they only work in other currency to Australian, and it doesn't look like they are going to do Aus support soon.

Apart from that, the IPN guide helps heaps as HuwR said.
Cheers,

David Greening
Go to Top of Page

seven
Senior Member

USA
1037 Posts
Posted - 08 February 2004 :  20:55:22  Show Profile  Visit seven's Homepage
The key to good IPN code is being able to test it...

I use this sites test environment: http://www.eliteweaver.co.uk/passpal/

Let's you try all sorts of scenarios on your code.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07