close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

pricing issues

Thread began 10/09/2009 10:01 am by tim.wolak331163 | Last modified 10/09/2009 8:46 pm by Jason Byrnes | 1465 views | 6 replies |

tim.wolak331163

pricing issues

I have a dynamic drop down list for dog food bags that have 6lbs, 18lbs and 38lbs, each of the pounds have a drifferent price which I have two tables in my DB. I have the dynamic drop down populated with the correct items(the bag weights) but how do I get it so when the user selects a bag weight the correct price is displayed in the cart? It sees as though my filter which is filter product_id = entered value product_id is not passing the correct options to the cart. Can anyone help?

Thanks
Tim

Product Category
product_cat_id
name

Product
product_id
product_cat_id
name
price

Sign in to reply to this post

chrisw_22390844

Just to add to that... We set up a recordset that grabbed the three weights based on a specific product category (Chicken, in this case). We bound this recordset to the cart, making the price updateable via a select list. The recordset has the necessary records, but the drop down list for the prices only has a single value instead of the 3 we were expecting. What is it that we're missing regarding binding a recordset to the cart? Seems like it should be straightforward...

Sign in to reply to this post

tim.wolak331163

support

Guys in support please help I would love to go live with this site before Monday. You can check out my issue at bnbfood.php

Thanks,
Tim

Sign in to reply to this post

Jason ByrnesWebAssist

the URL:
bnbfood.php

gives a 404 page not found error.


When you add the add to cart button behavior to the page, let eacart create the select list for you.


First create a recordset that returns all 3 bag sizes.

In the Add to Cart button, set it to lookup the item ID from a recordset, chose the recordset that returns all three bag sizes.

On the bindings tab, bind all of the columns to the recordset. Set the ID column to be updateble from a select list.


once eCart has added the select list to the page, select it in design view. I nthe Property inspector, click the dynamic button.

Set it to use the recordset that returns the three bag sizes. Set the Label to the description column, set the value to the ID column.

Sign in to reply to this post

tim.wolak331163

select list

Jason,

Thanks for the information. When I tried your suggestion, after I select the ID column to be an update able select list and then click on the dynamic button after selecting the list I can't change it because the system won't let me.

The page I gave you was wrong it is bnbfood.php

I'll be working on it so if you hit it and it messes up please try it again.

Thanks,
Tim

Sign in to reply to this post

tim.wolak331163

working but one question

Thanks I found out what you were talking about. How do I get the price to appear in the drop down list with the bag weights?

Thanks,
Tim

Sign in to reply to this post

Jason ByrnesWebAssist

you would have to manually modify the code for the select list to add the price as part of the label:
<option value="<?php echo $row_RecordsetName['ID']?>"><?php echo $row_RecordsetName['Name']?><?php echo $row_RecordsetName['Price']?></option>

Sign in to reply to this post

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