[ic] search query

[Philip S. Hempel]

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.

Any directions would be nice. If someone could point me to some doco
that would help.

-- 
Philip S. Hempel

Give a man a fish and he can feed himself for a day.
*Teach a man to fish and he will feed himself for a lifetime.*

http://linuxhardcore.com/