[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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/