View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Information on recordsets + ATC Function for items with size options that affect pric

Thread began 1/20/2010 4:28 pm by JLK | Last modified 1/28/2010 8:07 pm by JLK | 1946 views | 12 replies

JLK

Information on recordsets + ATC Function for items with size options that affect pric

I see from a thread on Dec 4 with Andre363997, a tutorial on adding products with options like size and color is on it's way - can you advise where it is?

My first problem was that the recordset options (in the Add to Cart on product pages) were not displaying in browsers - was advised it was due to my using CF - have switched to PHP and am getting the list dsiplayed.

Now, I need to understand if the data for a SINGLE cart needs to be in the same recordset - in this example a product that has 3 sizes and 2 colors. My database is already built with the needed foreign keys. And I can easily build simple recordsets - one for size, one for color and one for the product. However, since I'm not a PHP programer, I really don't understand the code beyond the recordset names. So I'm relying more on the ecart's wizards to build the php.

This is situation: my DB productID is to a size and color level, with sizeID and colorID as foreign keys to their own tables. Creating the options drop downs (as seen above) has been accomplished, but I don't understand how use the columns of the cart wizard to build it correctly so that the appropriate product is added to the cart.

I can see that I will need to enter dynamic information. I did create a recordset from the product table with productID, name, weight, price, desc. But this rs is not tied to the size so can't be used as is.

IF I have the rsSize include the sizeID (in its recordset for the page) AND the rsproduct include the sizeID (in its recordset page), will this somehow tie together (because it's in the same cart) so that when a customer is on this product page and chooses size L, that will translate to the appropriate price for the product ID that is associated with the productID/sizeID?? From the thread I referenced (up above), it seemed like maybe all info that affects the price would need to be in one recordset. But IF I can figure how to create a more complicated rs that combines all the needed data, I would have 3 records of the same product (same in all respects except size). But the page only needs one actual product. (EDIT - I did create a rs that included all information, but the same color was listed multiple times. And it would seem that I would need a separate recordset for separate data that I wanted sorted differently.)

Issue 2:
I'm assuming that since I've paid all this $ for this product, I will need to perservere until I grasp it and create the Add to Cart buttons. My next "problem" is going to be changing the presentation. Mostly with CSS, which for my first page was quite a bit of work. If I have pages with add to cart areas with similar options. Is there a way that I can copy the add to cart code from one page and paste it to another page, then hand code some changes - like recordset names? I know I will have to add the actual Add to Cart button to each page to ge the functionality, but want to be able to copy and paste as much as possible. Is there information on your site how I could do this?

Hope to hear from someone at WA soon. I've really really tried to figure this out on my own, but so far have not.
thanks

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...