Forum OpenACS Q&A: Response to Ecommerce Shopping Cart Change Quantities

Collapse
Posted by Dave Bauer on
Thanks. I thought the error was the "not in ()" part of this:
[17/Feb/2001:13:25:24][16947.968709][-conn26-] Error: dbinit: error(localhost::
nh,ERROR:  parser: parse error at or near ")"
): 'select max(item_id) from ec_items where product_id=1 and color_choice is nu
ll and size_choice is null and style_choice is null and order_id=27 and item_id
 not in ()'
[17/Feb/2001
I'll check the add to shopping cart routines to see if its inserting nulls or empty strings for non-existing attributes.