It is possible the recordset isn't returning the result. Maybe the coupon code was entered wrong. Maybe there is something wrong with the session variable storage.
You have to write those values to the page and see if you can track it down.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.