Webmaster Forum / ColdFusion / Advanced Techniques / November 2007

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