[ic] how to write in [search-region..

[Greg Goble]

Grace writes:
 
> How to write in [search-region.. 
> 			co=yes
> 
> 			sf=status
> 			se=canceled
> 			op=eq
> 
> 			sf=status
> 			se=expired
> 			op=eq
> 
> to express the following statement?
> where status eq 'canceled' or status eq 'expired'


Grace,

Sounds like you're doing the same thing I'm doing. 

Here's what I use:

[page search="
              sf=status
              se=expired
              se=cancled
              os=yes"] linked_text_here [/page]


OR you could also do an sql query...something like this:

[query list=1 sql="
             SELECT * from products
             WHERE status = 'expired' or status = 'canceled'
"]

Hope this helps. 

Regards, Greg