[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [ic] [query] + [filter] = fail


groove cube suppressed 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
 _/ _/    _/          _/ _/     _/    _/  _/_/    suppressed
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.