[ic] [query] + [filter] = fail
Kevin Walsh
kevin at cursor.biz
Fri Dec 23 11:09:05 EST 2005
groove cube [groovecube at gmail.com] wrote:
> [query interpolate="1" sql="select sku from products where sku =
> '1234567890'" list="1"]
> [list]
> [filter 3][sql-param sku][/filter]
> [/list]
> [/query]
>
Get rid of your list="1" and change it to type="list". That'll get it
to work.
Next, get rid of that interpolate="1" and change [filter] to [sql-filter].
That'll get it to be more efficient and prevent nasty surprises later.
You can also change [sql-param sku] to [sql-code], in this case, if you
like.
--
_/ _/ _/_/_/_/ _/ _/ _/_/_/ _/ _/
_/_/_/ _/_/ _/ _/ _/ _/_/ _/ K e v i n W a l s h
_/ _/ _/ _/ _/ _/ _/ _/_/ kevin at cursor.biz
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/
More information about the interchange-users
mailing list