[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Wierd behaviour mysql query - URGENT
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