9 Replies Latest reply: May 19, 2014 10:02 AM by David Pantich RSS

    Why does this WHERE clause result in Script Error?

    David Pantich

      Hello,

       

      I'm trying to read users from the Active Directory. Since there are so many records in the AD, I'm trying to add a WHERE clause to limit the number returned.

       

      I can run the following script in debug mode, set number of recs to bring back to 500 and it works fine.

      2014 0519_09.04.20.AM_0001.jpg

      However, if I add the following WHERE statement I get a Script Error

         WHERE length > 0

      2014 0519_08.57.46.AM_0000.jpg

      Can anyone tell me why that WHERE statement would cause a Script error?

       

      Thanks in advance for any help.