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 options
WHERE 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?