[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