Order Details Page

I am having trouble getting this page to show up, I get this error when I try to bring it up in my browser.

Unknown column 'WADAOrderID' in 'where clause'

My Order Details Page is attached.

you have a couple of problems in the recordset.


1) Create a new parameter:
Name: WADAOrderID
Type: Integer
Default Value: -1
Run Time Value: $_GET['OrderID']


2) Edit the paramUserID parameter, you currently have the run time value set to use:
$_GET['OrderID']

it should be set to use the user ID session variable. the example from the tutorial is:
$_SESSION['UserID'].


but you will need to double check that is the session ceated by you login page.

to find the session name to use, go to the login page, double click the authenticate user behavior, go to step 3 and make not of the session name for the ID column.

Ok that fixed the problem. How do I get the Size column to show the actual size that they ordered?

I guess I should ask, how do I populate the Size column in the OrdersDetail table with the size they actually ordered?

on the confirm page, edit the eCart Store Cart Details server behavior, bind the DetailProductSize column to the Size column from the cart.

I put <?php echo $LuckiexLosersCart->DisplayInfo("size"); ?> in the value field and I also change the type to text and it still doesn't display the sizes.

Nevermind, I had to change the Type field in my database for the size column.

are you testing by placing new orders? This will not fix orders that have already been placed, only new ones.

I need to add one more server behavior on "eCart confirm page" similar to "eCart Store Details to Database" in order to store Order ID in a different table "work_orders" at the same time when Order is Submitted.
Tried creating - it asks for to set the value of the column specified as Cart ID. How to get around it?

Can you please suggest how to post OrderID into to tables on database at the time when button "Submit" is pressed on eCart confirm page.

the order id is a session variable created by the Store Order Summary behavior.

double click the store order summary behavior and look in the session variable section to find the name of the session that will be created.

in the store order details behavior, set the Order ID column to the column that will hold the order number and bind it to the session created by the store order summary behavior.