checkout_success.asp suddenly not working

I'm using eCart 4 and ASP. I've had the checkout_sucess page working fine for a long time now, but suddenly it seems to have failed.

The success page uses Universal Email to send a receipt, shows the order ID and customer email in the confirmation text and updates the Orders table entry to "Paypal Success".

The email is being sent fine, but I'm getting a database error on the page itself when it attempts to show the order ID. It looks like the recordset isn't being found from the Orders table on the page itself, but it is being found for the Universal Email part as all order and client details are being shown perfectly in the received email.

Can you shed any light on this for me please? I can post any relevant files here or via a ticket as you wish.

Many thanks, Simon.

Please post back with a copy of the checkout success page so that I can take a look, along with this please also include a copy of your Universal Email folder from your site root. I will check on things and let you know what I discover or if I have any further questions or requests for you.

This post has been deleted.

Attached,
Simon

I'm a little confused by what I see on your page and what you are describing. It seems that the code is for the reference to this id is this:

rsReturn.Fields.Item("OrderReferenceID").Value

If it is showing in the email ok then it should also show in the page itself. One thing that you could try to do is set a session variable to this value, then use that session variable in both the email and the display on the page. You could set the session variable like this:

Session("your session var") = rsReturn.Fields.Item("OrderReferenceID").Value

You would do this just after the recordset on the page, then update anywhere that the old value was used and replace it with this session variable. This should ensure that you see the same result in both the page and the email.