View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

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 bjgarner241692 | 1714 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.

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...