[ic] search query
Stefan Hornburg
interchange-users@icdevgroup.org
Thu May 22 15:39:01 2003
On 22 May 2003 14:56:56 -0400
"Philip S. Hempel" <pshempel@linuxhardcore.com> wrote:
> I am trying to get a search to function like the sql query below does
>
> SELECT `page` FROM `tree` WHERE 1 AND `mgroup` = 'Products' AND
> `msort` = '0' AND `page` != ' '
>
> So far I have this it at least. The search returns the desired
> information except I am confused as to how to not return data if a
> certain field is empty. I am not sure how to describe null or empty. I
> have tried some things like using perl regex like [\w|\W] (I am certain
> that is not correct format)
>
> [loop
> search="
> fi=tree
> st=db
> tf=sort
> ac=0
> ac=0
> co=yes
>
> sf=page
> op=ne
> se= <<- this is where I am lost how do you describe null or empty?
>
> sf=msort
> se=0
> op=rm
>
> sf=mgroup
> se=Products
>
> "]
>
> ====
>
> The goal is to not return on field "page" being empty.
What about op=rm se=\S ?
>
> Any directions would be nice. If someone could point me to some doco
> that would help.
>
http://www.icdevgroup.org/i/dev/docfly.html?mv_arg=icdatabase06%2e04
Ciao
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team