OrderDetailID Cannot be Null

I'm trying to add the Store Order Details in Database Behavior.

The Order Summary is working fine; I have the the OrderID set to save as a session variable (currentOrderID). currentOrderID does not show up as a session variable in the Bindings window (even after refresh, recreate site cache, etc.).

So I have no way to reference the OrderID in the Store Order Details behavior.

trainingcheckout_success.php attached.

Thanks,

Mike

if there is no binding for the currentOrderID session, you need to create it.

on the bindings panel, click the plus button, select Session and name it currentOrderID


If it fails to create the binding, use the OS files system browser to borwser to your site and delete the _notes folder, then create the binding again.

Okay -- got this working.

Now have another problem. The Store Summary behavior works great -- I can come back and enter another order and the Summary data is stored in a new order. However the Store Details behavior hangs up when it tries to add the record i get the error "Duplicate entry '1' for key 'PRIMARY'" I presume this is about the Primary key for the Details Table.

I have the OrderID set as the key column for the Summary, and it is stored in the currentOrderID Session variable. DetailID (the Primary key field in the Details table) is set to auto-increment; the error occurs when there is an existing order (Number 1) detail record.

The file is attached. . .

Thanks,

Mike

in the store order details, you have bound the detailID column to the cart ID column.

the order details primary key column, the detailsID column, should not be bound to anything. remove the binding for that column so it can assign the ID automatically.

Huh -- didn't do that on purpose. . .

Phantom keyboard press strike again :-(

Thanks. . .

hate those phantom keyboards.....

you should get a standard qwerty ;)