[ic] Inactive
Ed LaFrance
edl at newmediaems.com
Mon Sep 22 11:01:55 EDT 2003
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
===============================================================
More information about the interchange-users
mailing list