Using Session Variable & Recordset to show Discount

I'm struggling with sending an order copy to the client after returning from PayPal.

On the Order Confirm page generated by the Checkout Wizard I have a UE behaviour to advise the vendor of the order.

Discount is set by matching a form field value to a value in the database with a corresponding discount. This works perfectly on the viewable page as well as the email.
As this page loads, I am also creating a session variable which = the value entered in the coupon field.

Parameter on recordset is:

<%
Dim coupons__Param
coupons__Param = "-1"
If (cStr(Request.Form("coupon")) <> "") Then
coupons__Param = cStr(Request.Form("coupon"))
End If
%>

Customer then checks out with PayPal and returns to the site to a thankyou page which again shows their order and triggers an email to them.

Because the Form is now history, the value used above is no longer available so I edited my Recordset on the Thankyou page to use the Session variable:

<%
Dim coupons__Param
coupons__Param = "-1"
If (Session("coupon") <> "") Then
coupons__Param = Session("coupon")
End If
%>

This does not work on the displayed page or the email generated by UE. The discount does not show. All other variables show up properly.

I realize this covers more than UE, but I believe the solution is one and the same. If I can get it on page, it will be in the email, so how do I retrieve this value that was entered on the Checkout page and populate the Discount section of the Shopping Cart.

Make sure the session variable has a value by writing it to the page:

coupon = <%= Session("coupon") %>

if there is no value, double check that it is getting set on the checkout page.

From you description, I can only think that the session variable is not being set.

Yes, it is being set.
It displays fine on the first confirmation page, but not the one after return from PayPal.

What about when you add:
coupon = <%= Session("coupon") %>

to the page when you return from paypal?


What is the URL when on the first confirmation page versus the page when you return from paypal?

can you post those to URLs?

Sorry. My above post was incorrect.
The Session Value DOES appear on the Order Complete page which is Post PayPal.

The only thing that is failing is the triggering of the discount.

I got it.
In my included eCart.asp page I was calling the value from the form. I switched it to call from the Session.Variable instead and it all works perfectly.

The solution was in leaving the project yesterday and taking a fresh look today.

Excellent, glad to hear it is working.