[ic] omitting sku's in the results.html

Greg Goble interchange-users@interchange.redhat.com
Tue Mar 26 08:52:00 2002


As a former Minivend user and listserv subscriber,
I'm now back on with IC and upgraded to IC 4.8. I've
searched the archives, but can only find info on how
to return searches, sorts, etc., but not how to avoid
or omit certain sku's.

I'm using this in my results.html

[search-region]
[search-list]
[sort products:sku:n] 
...

and I DO get the results I want, except
that I do NOT want to load sku's that
have "archive" under the column in
products.txt labeled 'status'

sku |  status      | etc
===============
001 |  confirmed   | etc
002 |  confirmed   | etc
003 |  archive     | etc

I was trying the WHERE status != 'Archive' in different
tags, but nothing seemed to work.

Please don't reply with "try perl" I'm
not a perl programmer ;-) 

Thanks in advance! Greg