close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Using Session Variable & Recordset to show Discount

Thread began 8/20/2009 7:48 pm by bjgarner241692 | Last modified 8/21/2009 3:07 pm by Jason Byrnes | 1817 views | 6 replies |

bjgarner241692

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

bjgarner241692

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

Sign in to reply to this post

Jason ByrnesWebAssist

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?

Sign in to reply to this post

bjgarner241692

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.

Sign in to reply to this post

bjgarner241692

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.

Sign in to reply to this post

Jason ByrnesWebAssist

Excellent, glad to hear it is working.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...