CFLDAP filter for NULL value

[KevinFSI]

Is there an equivilant to IS NOT NULL using CFLDAP filters?
I want to return a list of LDAP entries, but I want to exclude records where there is NOT an e-mail address.

I tried:
!(mail=NULL)
!(mail=NUL)
!(mail=\00)
!(mail='')

 

[ecobb]

I have no clue if this will work or not, I haven't fooled with LDAP in a couple of years, but have you tried:

filter="mail IS NOT NULL"

or 

filter="mail <> ''"

Unless you're returning A BUNCH of records with NULL emails, I wouldn't worry about it. Just pull back the info, then let CF sort through whether or not they're NULL.

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[KevinFSI]

Thanks for the response. Actually, I figured out if I put FILTER="mail=*" it will ignore empty strings and nulls. So, it's a backwards way of doing it (at least I feel like it is) but it works.