Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Product Options - Metal/Color and Size

Product Options - Metal/Color and Size

Thread began 9/19/2011 11:39 am by Patbyrne322425963 | Last modified 11/01/2011 6:50 am by Patbyrne322425963 | 6605 views | 31 replies

9/19/2011 1:40 pmJason ByrnesWebAssist

in the rsMetal recordset, you are suing the productoptions.ProductCategory column in the where clause:

WHERE optiongroups.OptionGroupName = 'Metal' AND productoptions.ProductCategory = paramItem

you need to use the productID column:
WHERE optiongroups.OptionGroupName = 'Metal' AND productoptions.ProductID = paramItem

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.