ASP Options on Category page

4/15/2010 11:23 pmbjgarner241692

ASP Options on Category page

I have a site where some, but not all products have options. The options vary by product. There is no price associated with the options. They are things such as size or colour.

I have a working Category page, on which I have a Buy now button leading to a Product Details page. On the Product Details Page, I am able to call up the options by linking the tables in the RecordSet. Adding to cart at this level is no problem. Everything works fine.

What I would like to achieve, is to eliminate the Product Details page but I cannot get the options to display properly on the Category Page.

I can envision the resolution, but I cannot code it.

What I need is a second recordset for options that would look something like this.

rsOptions

SELECT *FROM optionsWHERE prodname = param

param = prodname from rsProds

I've tried doing it with a hidden form and field but that failed and I've tried calling the rsProds.prodname field directly but I cannot get the syntax to work.

If I could get rsOptions to work, the rest of it is easy. I can show or hide the options dropdown based on whether there is a value in rsOptions.

Can this be done?

0

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.

Rate your experience or provide feedback on this page

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 Window

We were unable to retrieve the attached file

Post a question as

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)