That helps but leads me to MySQL error message
That helps but leads me to MySQL error message.
The reason for the MySQL error message is that orderdetails.ordernumber is a int(11) ...which is a number with 11 digits. eCart Store Details in Database procedure is trying convert the "session characters"
8440a0599332f4b518e08e4c3d4bd100 to slpecart_OrderID and not the actual ordernumber from the orders table.
For testing purposes, I made a field called sessionnumber with varchar(50) and set the dynamic value <?php echo session_id("slpecart_OrderID"); ?> and it in turned... outputed a value of slpecart_OrderID in MySQL. (see pic below)
mysql_orderdetails_table.jpg
I presently have the orders.ordernumber inputing into orderdetails.ordernumber using a standard recordset through Dreamweaver. It's not a good fix but I'm sure there's got to be an anwser to this complete issue.
I welcome any suggestions... and thanks for your time.
Marty Anderson 717-241-5576