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

grace interchange-users@interchange.redhat.com
Tue Apr 16 21:16:00 2002


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

what's mean "linked_text_here"?
where to put "op=eq"?
and if i want to express
"where status='expired' or stauts='cancled' or deleted=1"
how to write code in [page search...?
>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