[ic] sql query ...

[Andrei Gologan]

> > I will look into item-calc, I dont know how to do that yet.
> >
> > The only visible problem on the outside is on the results page, if such
an
> > item is encountered and no output is generated, this means i cannot
output
> > an mv_order_quantity so the text input fields for the quantities get
shifted
> > by 1, so all bellow the special item have the wrong code , if i try to
order
> > , it will put in cart the item above.
> >
> > I think the sql query should go into no_match if there are no data
returned
> > , instead it seems that it does not know this answer .. am i right ?
> >
>
> Your problem is not that -- it is that the containing [item-list] is
> seeing the [no-match] section as its own.
>
> Try doing:
>
> [query prefix=sql list=1 sql="select * from ..."]
> [sql-list]
>                 [sql-code] -- [sql-price]
> [/sql-list]
>
> [sql-no-match]
> foo
> [/sql-no-match]
> [/query]
> --

I tried that, the result is that ic prints out all the code. I use IC 4.8.3
do you think an update would solve this problem ?

sincerily
Andrei