Order number not showing on confirm page
I'm not getting an order number on either the checkout_success.php page or the confirmation email. It doesn't look like the OrderID is connecting to anything.
I'm not sure if I need to add a recordset with the orders and orderdetails table to the confirm.php page or add them to the recordset on my add to cart page or if it is another issue all together.
I did move the order of the server behaviors - so that the Universal Email Server Behavior comes after the eCart Store Summary in Database and eCart Store Details in Database Server behaviors, but didn't change the redirects (as I wasn't sure which code to delete). While this didn't solve the order number issue everything else still worked.
I have attached my confirm.php page.
Thanks for your help in advance.