[ic] decrement inventory in an additional table

Kevin Walsh interchange-users@icdevgroup.org
Mon Aug 26 07:54:02 2002


> >
> > If rows in your "menge" table cannot be uniquely identified by the
> > item code then you will not be able to use the [data] tag in the
> > way you quoted above; Use [query] instead.
> >
> ok rows cannot be uniquely identified, one item_code comes more than once
> ... so i try this:
> 
> [if variable DECREMENT_INVENTORY]Inventory of [item-code] now:
> 
> [query sql="update menge set ( quantity='-[item-quantity]' ) where
> sku='[item-code]' and username='[data session username]'  " ]
> [/query]
> 
> [/if]
> 
> but that brings me back to checkuou.html
> 
You are close.  Now you just need valid SQL syntax.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/