LDAP-SQL help?

General Discussion about LDAP Administrator

Moderator: Support

LDAP-SQL help?

Postby emkay » Wed Jul 25, 2012 6:15 pm

Is there a list of functions available for LDAP-SQL? I'd like to do a query and INCLUDE only those users where the LENGTH of their employeeID field is < 7 -- however, neither a LEN() or LENGTH() function seems to work...
emkay
 
Posts: 2
Joined: Wed Jul 25, 2012 6:13 pm

Re: LDAP-SQL help?

Postby Support » Fri Jul 27, 2012 11:08 am

Hi.
The list of all SQL functions can be found in the local or online help, LDAP-SQL section (http://ldapadministrator.com/resources/ ... 04s01.html). In your case you should use CHAR_LENGTH function.
Support
 
Posts: 886
Joined: Sun Aug 12, 2001 12:00 am

Re: LDAP-SQL help?

Postby Sam Menges » Wed Jun 14, 2017 11:10 am

It seems that I need to add CHAR_LENGTH. Thanks a lot!
Sam Menges
 
Posts: 1
Joined: Wed Jun 14, 2017 11:06 am

Re: LDAP-SQL help?

Postby sarahah » Thu Oct 26, 2017 4:47 am

Support wrote:Hi.
The list of all SQL functions can be found in the local or online help, LDAP-SQL section (http://ldapadministrator.com/resources/ ... 04s01.html). In your case you should use CHAR_LENGTH function.

Thanks for the link. It is helpful to me. :)
__________________
Dealership Software | ERP GST Software
sarahah
 
Posts: 2
Joined: Wed Oct 25, 2017 5:39 am


Return to General Discussion

Who is online

Users browsing this forum: Bing [Bot] and 0 guests

cron