Product Options Issues

I'm using the Product Options tutorial to try to drop size and color options into my store.

When I test my store the dynamic list/menu is not populating. If I change the "Options from recordset" from my rsColor to the products record set, rsProducts, the list will populate with all of my products.

Here is my SQL Code:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.ProductOptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = paramItem

And the Variables
Name: paramItem
Type: paramItem
Default Value: -1
Runtime Value: $row_rsProducts['ProductID']

When I created my add to cart button I left the color "Default Value" blank under the Bindings tab. Should this have a database call in it? I'm also not doing a price increase so I didn't do anything with the sizeInc. calculations.

can you send a copy of the page so i can see the entire code in context, this will help me see where the issue is.

Here you go

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

Hi Rob

When you get a solution, could you post it here as I will soon be attempting this....

we found a problme in the SQL.


we edited the SQL to:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = paramItem


to get the options working.


This change will be made in the documentation as well.