eCart ID, binding to database
The orders are processing but the only thing getting into the database is the datetime of the order. The ID is not showing on the receipt either. Files attached. Thank You!
The orders are processing but the only thing getting into the database is the datetime of the order. The ID is not showing on the receipt either. Files attached. Thank You!
It looks like you are trying to set the order id to $row_rsOrders['orderid']. The id of your orders table should be set to an auto incrementing primary key column that is not null. If you have the orders table setup like this then the id will not need to be explicitly inserted for the order. You could choose to add another column to store the order reference id, this should be the session id that you can get from the bindings in eCart > [Session ID].
Ok I switched that to NOT allow null. Thanks! Can I bind additional fields and if so what page do I do this on?
You can bind additional fields in your store order summary or store order details sever behaviors. You just need to open the confirm or pp_confirm pages and edit the store order summary and store order details server behaviors. In here you should get to the step that lists all of the columns in your table and what values you are binding for them.
Now I just realized that I am binding to the wrong orders table. I need to bind to another table. Will this create alot of problems? If not, what page / pages are affected and do I need to modify.
Thank You
If you want to insert the data into a different table you should just modify the server behavior and select the table that you would like to insert into instead. You will need to still configure the values for the columns though just like you did the first time around. If you make a backup of your page first you can safely make edits to it.
choose_membership.php is refreshing the page and not going to the cart_display.php page
This was working, then we moved the site to another server. We are waiting on the SSL certificate
It looks like there are a couple of the add to cart server behaviors that do not have the redirect specified. Do you have the same result for all of the items on the page? What happens if you try to add the item to the cart then go to the cart display page manually afterwards? Do you see the item in the cart?
Please post back with these details so that we can look into this further with you.
You are correct, manually they do show up. I tried all of the buttons and none of them redirect. I do see some some redirect in the choose_membership.php page code.
I also double clicked on the button in the server behaviors. Is both the general and the bindings tab to be set to redirect to cart_display.php?
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.