2 Replies Latest reply on Nov 30, 2007 4:29 AM by Kev_in_the_UK

    Setting a variable to query cfldap

    Kev_in_the_UK
      I'm having difficulties querying cfldap - I hope someone can help. I have the following code

      <cfldap action="query"
      name="getaccount"
      start="ou=Live,ou=User Accounts,DC=internal,DC=westminster,DC=gov,DC=uk" maxrows="10"
      attributes="cn,sAMAccountName"
      filter="sAMAccountName=#user#"
      server="xx.xx.xx.xx"
      username="INTERNAL\username"
      password="password">

      I firstly get the variable "#user#" from the user's userid like this:

      <cfset domain = ListGetAt(get_userid.userid, "1", "\,/")>
      <cfset user = ListGetAt(get_userid.userid, "2", "\,/")>

      and then insert it into the cfldap query. Thing is it doesn't work - doesn't error or anything. However, if I was to go:

      <cfset user = "xxxxx"> where xxxxx is the actual userid of the user it works fine. Have tried using cfparam and got nothing but beyond this I have run out of ideas. Anyone help would be appreciated.

      Thanks from the UK