<div>
<div class="content wysiwyg-content">
I need to query LDAP using a variable as part of the select statement. This syntax won't work. Is is possible to do this and if so, how can I correct this so that it will work? Thanks!<br />
<br />
dim samvariable<br />
samvariable = johnD<br />
<br />
&quot;SELECT mail FROM 'LDAP://dc=fabrikam,dc=com<wbr />' WHERE objectCategory='user' &quot;&nbsp;&amp; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;AND sAMAccountName=&quot; &amp;&nbsp;samvariable<br />

</div>
</div>


I need to query LDAP using a variable as part of the select statement. This syntax won't work. Is is possible to do this and if so, how can I correct this so that it will work? Thanks!

dim samvariable
samvariable = johnD

"SELECT mail FROM 'LDAP://dc=fabrikam,dc=com' WHERE objectCategory='user' " & _
        "AND sAMAccountName=" & samvariable


Using  a variable in a SELECT statement when querying LDAP - VBScript

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.