This topic is locked

extra fields

7/2/2008 10:55:40 AM
Members Template General Questions
G
griller author

Hi

I need to pass some extra fields to paypal and then pass them back into the database when the user has payed
I have added 2 fields to the members database, "packagename" and "packagevalue"

I want these so that I can later use the values to detemine which package a user has paid for and impose limits.
I have added the following to the paypal_submit event
if request.form("ppal")="ok" and (session("ppuid")<>"" or request.form("uid")<>"") then

if request.form("uid")<>"" then session("ppuid")=request.form("uid")

if request.form("paytype")<>"" then ptype=request.form("paytype")

Set rstmp = server.CreateObject("ADODB.Recordset")

tmpSQL="select from prices where ID=" & ptype

rstmp.open tmpSQL, dbConnection

price=replace(rstmp("Price"),",",".")

packagename=replace(rstmp("Packagename"),",",".")

packagelevel=replace(rstmp("Packagelevel"),",",".") rstmp.close

tmpSQL="select
from options"

rstmp.open tmpSQL, dbConnection

IPNPage=rstmp("IPNaddress")

psuccess=rstmp("Successpage")

pcancel=rstmp("Cancelpage")

email=rstmp("Ppemail")

rstmp.close

info = "<BODY onload=""document.forms.xclick.submit();"">"

info=info & "<FORM name=xclick action=""https://www.paypal.com/cgi-bin/webscr""; method=post>"

info=info & "<input type=""hidden"" name=""cmd"" value=""_xclick"">"

info=info & "<input type=""hidden"" name=""business"" value=""" & email & """>"

' info=info & "<input type=""hidden"" name=""currency_code"" value=""" & dataInfo("Currency") & """>"

info=info & "<input type=""hidden"" name=""item_name"" value=""Registration"">"

info=info & "<input type=""hidden"" name=""amount"" value=""" & price & """>"

info=info & "<input type=""hidden"" name=""quantity"" value=""1"">"

info=info & "<input type=""hidden"" name=""item_number"" value=""" & SESSION("ppuid") & """>"

info=info & "<input type=""hidden"" name=""custom"" value=""" & ptype & """>"

info=info & "<input type=""hidden"" name=""package"" value=""" & packagename & """>"

info=info & "<input type=""hidden"" name=""level"" value=""" & packagelevel & """>"
How do I post this to paypal and then update the database with the extra fields on customer completing payment?

admin 7/4/2008

Your code looks good to me.
Just make sure the following appears as two lines in your code:

packagelevel=replace(rstmp("Packagelevel"),",",".")

rstmp.close