[ic] Return best sellers from a single category?
Kevin Walsh
kevin at cursor.biz
Sat Apr 19 19:22:21 UTC 2008
"IC" <ic at tvcables.co.uk> wrote:
> "IC" <ic at tvcables.co.uk> wrote:
> > Thanks for the reply, I have modified the search to this:-
> >
> > [loop search="
> > co=yes
> > sf=category
> > se=my category name
> > nu=0
> > op=eq
> >
> > sf=merchandising:times_ordered
> > se=1
> > op=ge
> > nu=1
> >
> > tf=merchandising:times_ordered
> > to=rn
> > ml=[control matches 3]
> > "]
> >
> >
> > This returns 3 products from the correct category however it does not
> return
> > the 3 best sellers according to the times_ordered field, is there
> something
> > else missing?
> >
> >"op=ge" is not appropriate for numeric columns (nu=1).
> >Try "op=>=" instead.
>
> Just tried that, still no joy, it seems to be the sort order at the end that
> doesn't work, must be something IC doesn't like with the tf or to lines? Any
> other ideas?
>
Presumably you've tried removing the table name from the "tf"
parameter. The "tf" parameter only expects column names and optional
sort options:
http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_sort_field_tf
--
_/ _/ _/_/_/_/ _/ _/ _/_/_/ _/ _/
_/_/_/ _/_/ _/ _/ _/ _/_/ _/ K e v i n W a l s h
_/ _/ _/ _/ _/ _/ _/ _/_/ kevin at cursor.biz
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/
More information about the interchange-users
mailing list