[ic] Newbie Help Please

Curt Hauge interchange-users@icdevgroup.org
Wed Jul 31 20:39:01 2002


eelamae kanavu wrote:
 
>    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.

I am assuming you were showing ALL of your code here...

You forgot to add this:

[loop-data merchandising featured]<br>[/loop] 

This is where I found the info:

http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=ictags03%2e02

There is much info there and in the mailing archives here:

http://www.icdevgroup.org/cgi-bin/ic/mailinglists.html

Good luck!


Curt Hauge

//////////////////////////////////////////////////////////////////
// Web Design - Interchange Hosting - Small Business Consulting //
// 1525 Meadowwood Drive                    www.mnwebdesign.com //
// Brooklyn Park, MN 55444             www.iwantaconsultant.com //
// Phone 612-598-5530                      info@mnwebdesign.com //
//////////////////////////////////////////////////////////////////