Forum OpenACS Q&A: Response to SQL: how do you do this?

Posted by David Walker on
Try as I might I can't seem to understand what you are trying to do.

It looks like an items and an item_quantity table with default_q and selected_q representing the default quantity and selected quantity and I can't fathom why that would need to reference the quantity table. I would presume the quantity table would contain the current quantity.

Perhaps you can expand on this a bit.