[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