Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › order submission with eCart Store Summary & Details in Database

View all replies to this thread

order submission with eCart Store Summary & Details in Database

Thread began 3/26/2010 3:46 pm by manderson279060 | Last modified 4/01/2010 11:14 am by manderson279060 | 4138 views | 12 replies

3/26/2010 8:59 pmmanderson279060

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

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.