[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