[ic] Newbie Help Please

[Rene Hertell]

> 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.
>
> Would someone please be able to point me to the
> correct direction as to where I can get some more
> information on this issue.

I prefer myself the query-tag. It is much easier for me to get it to work.
Your case would look like this:

[query list=1
       sql="select sku
            from merchandising
            where feature='specials' and cross_category='Hammers'"]
[sql-param sku]<br>
[/query]


Rene