close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

How do I sort data in this case?

Thread began 12/02/2009 7:14 am by rikaG_510 | Last modified 12/05/2009 8:40 am by rikaG_510 | 3599 views | 6 replies

Eric Mittman

Sorry about the lack of response, the last time I saw this I thought you were involved in a specific conversation so I did not want to but in.

I think the best approach for your options scenario would be to have a table that will have a record for each option, this record would need the option name, the item id to associate it with and a price that will add to the price of the item. I think this is the best way to keep the options and products organized.

On a product detail page you could then have a recordset that selects all of the options for that particular item. You can use this recordset to populate a select list with the options. Getting the price to add to the items price requires a couple more steps though. For the option select list you have should have the option name for the label and maybe also list the additional price for that option in the label as well. For the value you should have the id of the option. Then when the user submits the form to add the item to their cart you will need to have another recordset that selects from your option table and filters based on the posted option id. You can then use the bindings from this recordset to get at the price and name for the option to include in your add to cart. You can add the price to the price for the item and include the name of the option in the corresponding cart column.

Let me know if you have any different ideas for how you would like to implement this or if you have any questions in general about how you can accomplish this.

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