Interchange Developer Resource
[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

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



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 


Search for: Sort by: