[ic] Mike H, one step at a time

Greg Goble interchange-users@interchange.redhat.com
Wed Mar 20 04:09:00 2002


steffen,

If I do not want to display 
an item that has a column
in products 'archive'. How would
I put this into my fly page.

I only want to display items
that have a confirmed or pending
status. Anything in archive status
should not be displayed.

IC uses something like this in the
foundation index.html, but I need
this in my results.html

[query list=1 prefix=loop sql="SELECT title, date, location, category
FROM products
WHERE status != 'archive'  
"]

ideas?

thanks, Greg