Building the classifed page itself wasn't difficult. But how can a payment program be integrated so it know how much to charge by reading the submission data to the database. The problem I find is this:

Either I can SUBMIT the input info to the database OR the payment program. How can the same submission hit both?

I felt this is a better spot than the business forum. Thanks again all in advance.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

1- Cant you use and <if> statement to A)verify that card was accepted/authorized and B) if so, post to your databse.

2- I have used authorizenet in the past and they have options that allow the data (once authorized for charges) back to your site so that you can collect the info as needed.

I know this doesnt really help you but thought I would throw it out. Keep us posted.

-------------
Brian---

[This message has been edited by Bnugent (edited 02-21-2001).]

Pay Pal is cool. They email the funds to your account. Either they have the money to email or they don't. My wife uses it all the time (she makes and sellsquilts online). It seemed a little strange to me at first, but it works great.

I am curious about this posted topic myself...
Joe

Ive not used it yet, but thought about it before Tom went with Authorize

Yes it does seem good. It is NOT a shopping cart, so only 1 item can be purchased at a time, I BELIEVE. I have not yet signed up so I can't be sure.

Spooky, after I sign up, I will send you the code or you could see a bit of sample by going to www.paypal.com and going through their demo (or go to link below). It seems like good ole HTML which leads me to believe you could use ASP to pull in a dollar amount (you would normally hard code the dollar amount).

http://www.paypal.com/cgi-bin/webscr?cmd=p/web/index-outside

I am going "on the road" in the few days so this may not get done for a couple of weeks. In either case, this sounds interesting.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

[This message has been edited by hzarabet (edited 02-22-2001).]

<%
Dim ValPrice
ValPrice = "9.99"
%>

<INPUT TYPE="hidden" NAME="amount" VALUE="<%=ValPrice%>">

Obviously you would fill ValPrice from database or some other input

In the HTML is a "return" URL to go to after the PayPal process is done. Depending on which of the four options they paid for, they will be directed to one of 4 different submit forms, only giving them the options that are coordinated with the price they just paid!!

VOILA!!!

I will try both ways and see how they go.

Thanks again for your expertise Spooky!

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

I am passing a database result through to PayPal. Per your response above:

<%
Dim ValPrice
ValPrice = FP_FieldVal(fp_rs,"Price")
%>

VALUE="<%=ValPrice%>"

Here is the error message I get:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'rs'

/_fpclass/fpdblib.inc, line 12

Thanks for your help.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

SELECT ad_data.AdName, ad_data.Target, ad_data.DateStart, ad_data.DateEnd, ad_data.ImpressionsPurchased, ad_proposal.guarantee, ad_proposal.price, ad_proposal.email, Users.x_email, Companies.ContactEmail, Companies.CustomerID, ad_data.CustomerID FROM (ad_proposal INNER JOIN Users ON ad_proposal.email = Users.x_email) INNER JOIN (ad_data INNER JOIN Companies ON ad_data.CustomerID = Companies.CustomerID) ON Users.x_email = Companies.ContactEmail WHERE ad_data.status='hold' AND ad_proposal.email=Users.x_email AND Users.x_email = Companies.ContactEmail AND Users.UserName='"&Session("UserName")&"'

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

Instead of using DIM, I tried to insert the following <%=FP_FieldVal(fp_rs,"999")%> (this is my Price field) directly into the PayPal and I get a PayPal error message leading me to believe that the price field ONLY accepts numeric values. I tried this with the item name field and it did work (this field does not require numeric values). I will call PayPAl and report back.

BTW, I got rid of the RS problem by placing the final gray "Include" code after the PAyPAl HTML.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada