close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Multipled Cart Storage - Retrieve & Continue Later

Thread began 12/20/2011 7:58 pm by codamedia | Last modified 12/22/2011 6:06 pm by codamedia | 959 views | 2 replies

Jason ByrnesWebAssist

there is no documentation for doing this that I can point you to.

you would need to create 2 tables in your database.

the first table will have a primary key column, another column to store the ID of the logged in user, and a text column to store a name for the saved cart.

the second table will have a primary key column, a column that relates the ID column from the first table and additional columns for each of the columns in your eCart object. for example:

cart:
cartID - primary key
cartUser - relates to user.userID
cartName

cartdetails:
cartdetailID - primary key
cartdetailcartID -relates to cart.cartID
cartdetailProductID - stores the ID column of the cart
cartdetailProductName - stores the name column from the cart
etc...


on the page that you add the Save Cart button, add a textfield to set the name of the cart.

then use the eCart Store Order Summary behavior to create a new record in the cart table for the order. bind the cartUser column to the user ID session variable, bind the cartName column to the text field. set the OrderID column to use the primary key cartID column and make note of the name that is set in the Store As section.

Next add the eCart Store order Details behavior. Set the Order ID to use the cartdetailCartID column, bind that column to the session variable created by the Store Oder Summary behavior.

Bind each of the additional columns to the corresponding column in the cart object.

You now need to create a page to show a listing of the saved cart. use recordset that queries the cart table and filters the cartUser column on the users ID.

use a repeat region to show the cart name for each record returned. use the cart name as a link to a page that will populate the cart with the corresponding items by passing the cartID as a querystring variable

on the page that will populate the cart, create another recordset that will query the cartdetails table, filter the cart details table using the cartID querystring variable.

on the server behaviors panel, click the plus button and select eCart -> Add to cart -> Get Contents from recordset to use the recordset to repopulate the cart.

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...