[ic] Newbie Help Please

[interchange-users@icdevgroup.org (Stefan Hornburg Racke]

eelamae kanavu <eelamae@yahoo.com> writes:

> Hi there,
> 
>    I am a newbie to Interchange.  I have been trying
> to write the following query in the [loop
> search="..."] tag.  
> 
>    The query in sql is as follows;
> 
>    select sku from merchandising where
> feature='specials' and cross_category='Hammers'
> 
> I tried quite a number of queries including the
> following,
> 
>   [loop search="fi=merchandising
>                 st=db
>                 co=yes
>  
>                 sf=featured
>                 op=rm
>                 se=specials
>                 os=no
>                 sf=cross_category
>                 op=rm
>                 se=Hammers
>                                    "]
> It looks like I am doing something wrong because the
> above query does not produce the correct result set.

Try op=eq in both cases and watch your SQL server log for
IC's query.

Ciao
        Racke

-- 
Prolific Interchange Consulting (Excellent German Quality !).
Take a look at Materialboerse (http://www.materialboerse.de/), WITT 
(http://www.witt-weiden.de/), Boxmover (http://shop.boxmover.ch/) or 
Passionshop (http://www.passionshop.com/racke). Need a shop ? Contact us.