[ic] Inactive

[Ed LaFrance]

At 09:06 AM 9/22/2003 -0700, you wrote:
>  Can someone tell me why the following code may not be working?
>
>I'm trying to have it so that any product with the inactive field set to "1"
>doesn't show up. I was able to make it work when pulling from only one field
>but in the code below I'm pulling from two fields "Protective Gear" and
>"Accessories" and for some reason the inactive code isn't working.
>Any ideas?
>
>  [table-organize embed=1 pretty=1 cols="[control cols 2]"]
>     [loop
>         random="[control matches 2]"
>         search="
>
>         fi=products
>         st=db
>         sf=prod_group
>         se=Protective Gear
>         op=rm
>         nu=0
>
>         os=yes
>         sf=prod_group
>         se=Accessories
>         op=rm
>         nu=0
>
>         sf=inactive
>         se=0
>         op=ne
>         nu=0

The above will find records with the inactive field not equal to 0. That is 
the opposite of what you want, try changing your se=0 to an se=1

- Ed

P.S.: If you are using an SQL db, save yourself the hassle and gain 
performance by doing this as a [query] instead.



>         ml=50
>         tf=price
>         to=n
>
>
>--
>Anthony
>
>_______________________________________________
>interchange-users mailing list
>interchange-users at icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax
===============================================================