[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