Good Afternoon Jason,
Thanks for the reply. That's what I had been attempting to do, I think. After successfully setting everything up to work with the tutorial 'as is' I went back and created a recordset for rsColorLookup. Not having a good knowledge base on the coding I changed the record set slightly using rsSizeLookup as the base. Swapping out 'size' with 'color'. When I open the 'eCart Add From Record Set' and select 'color' then attempt to uncheck 'updatable' and bind it in the same way as 'size' is to 'sizePriceInc' it seems to go fine, but when I hit 'ok' to get back to dreamweaver my list/menu for color disappears completely. Maybe I'm just going in a faulty order or something, but trying to follow the directions for 'size' exactly to create this one.
Appreciate the continued support.
Here is what the recordsets looks like:
Name: rsColor
SQL: 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
Variables:
Name: paramItem
Type: Numeric
Default value: -1
Run-time Value: $row_WADAproducts['ProductID']
Name: rsColorLookup
SQL: 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.ProductOptionID = paramOption AND productoptions.ProductID = paramItem
Variables:
Name: paramOption
Type: Numeric
Default value: -1
Run-time Value: $_POST['maddenBMX_eCart1_1_color_Add']
Name: paramItem
Type: Numeric
Default value: -1
Run-time Value: $_POST['maddenBMX_eCart1_1_ID_Add']
