Forums :: PayPal IPN :: DwZone Forum

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

PayPal IPN

DwZone Forum Index -> PayPal IPN

Moderators: Administrators, Moderators Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 21 to 30 of 76 (Total: 29)

First | Prev | Next | Last

Subject Author Date

Re:Help with Database Update

[email protected]

2:50 29 Jan 2008

Re:Help with Database Update

[email protected]

14:19 23 Oct 2008

updating database based on paypal "custom" field?

[email protected]

14:51 27 Sep 2007

Hello,

my log shows everything is verified but I am trying to do an update to a record by passing custom value as the Customer_ID wich is record id in database to update.

When I do the transaction I see it is all verified and the custom id shows correct for the record in the log file

- first_name: Test
- custom: 105

but I get.

START ERROR INFO
- Error Number:3021
- Error Description:Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
- Error Function:Ger value - Recordset1:first_name -
END ERROR INFO

my update code

PayPal_IPN.SetConnection MM_mhp_reg_STRING
PayPal_IPN.SetPayPalPage "https://www.sandbox.paypal.com/cgi-bin/webscr"
PayPal_IPN.SetFieldList "Item_Name;Item_Number;Payment_Status;Mc_Gross;Mc_Currency;Txn_id;Payer_Email;custom;payment_date"
PayPal_IPN.SetLog "true", "photos/"
PayPal_IPN.SetMailOnError ""
PayPal_IPN.SetVerify "false;false;false;false;true", "None;None;None;None;Txn_id", "None;None;None;None;Recordset1:Txn_id"
PayPal_IPN.AddTransaction "Update", "dbo.tblCustomer", "None", "Verified", "None", "payment_date_@@_PayPal: payment_date_@@_Text,Null_@@_;_;payer_email_@@_PayPal: Payer_Email_@@_Text,Null_@@_;_;item_name_@@_PayPal: Item_Name_@@_Text,Null_@@_;_;Txn_id_@@_PayPal: Txn_id_@@_Text,Null_@@_", "Customer_ID_@@_PayPal: custom_@@_Numeric,Null_@@__@@_="

My recordset
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.Form("custom") <> "") Then 
 Recordset1__MMColParam = Request.Form("custom")
End If
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_mhp_reg_STRING
Recordset1_cmd.CommandText = "SELECT * FROM dbo.tblCustomer WHERE Customer_ID = ?" 
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam) ' adDouble

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>

I am confused why the data is not updating. I am sorry, not the best at asp hence the reason I purchased the extension to begin with lol.

Thank you for any help =)