[ic] Wierd behaviour mysql query - URGENT

Stefan Hornburg interchange-users@icdevgroup.org
Wed Oct 16 08:53:01 2002


On Wed, 16 Oct 2002 14:33:12 +0200
"Andrei Gologan" <agologan@gmx.mis.de> wrote:

> Hallo,
> 
> we have following code that worked  until a few days:
> 
> [if-item-data products limitiert eq 1]
> [query list=1 sql="SELECT Id, quantity FROM menge WHERE username='[data
> session username]' AND sku='[item-code]'"]
> [on_match]
> [if type=explicit compare="[calc][sql-param quantity] > 0 [/calc]"]
>  <font __FFACE__ size="1" color="#008000"><b> [sql-param
> quantity]</b></font>
>  [else]
> <font color=red>No</font>
> [/else]
> [/if]
> [/on_match]
> 
> [no_match]
> <font color=red>No</font>
> [/no_match]
> 
>  [list]
>  [/list]
> [/query]
> [else]
> ..............
> [/else]

I don't see the closing [/if-item-data]

Ciao
       Racke