Adobe Community: Message List - objectGUID in a ms sql databse in a varchar(100) column

Re: objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Tue, 28 Oct 2014 15:26:01 GMT

Using afceait's sample from March 28th above, you can filter on objectGUID by escaping the converted binary sthex substrings with '\' as shown here:

Then you can do
<cfldap .....

filter = "objectGUID=#SrchStr#"

...

Re: objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Fri, 28 Mar 2014 14:26:35 GMT

<cfldap

server = "server ip/name"

username="adminuser"

password="adminpass"

action = "query"

name = "results"

start = "CN=Users,dc=domain,dc=org"

filter = ""

attributes = "objectGUID,cn,displayName,givenName,sn,DN,o,Description,company,department,physicalDeliv eryOfficeName,title,mail,telephonenumber,mobile,streetAddress,l,st,postalCode,c,info"

returnAsBinary="objectGUID"

sort = "sn ASC">

#displayName#: ObjectGUID before: #sthex# | objectGUID Parsed: #TempGuid#<br>

</cfoutput>

Re: objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Fri, 10 Jul 2009 12:27:05 GMT

Does anyone know how to do the reverse of

so that you can use the objectGUID in the

<cfldap filter

Re: objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Fri, 10 Jul 2009 12:25:54 GMT

This is the magic code:

Re: objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Wed, 08 Jul 2009 16:02:24 GMT

Mabye this is the solution from another website:

Can anyone please explain how to get the objectguid binary attribute from Active Directory using cfldap and store it in the database? I need this so as to maintain a global unique id both in the AD and in my database for the users. Thanks

You'll probably have to use JLDAP for this - CFLDAP has many shortcomings that we've used JLDAP to work around. It's a very simple API and everything works from within CF. I've blogged a few of things we've done, so that should get you started:

http://www.d-ross.org/index.cfm?objectid=9C65EEF0-508B-E116-6F30CA79F5BFDE07

http://www.d-ross.org/index.cfm?objectid=9C65EF0F-508B-E116-6F851C474448E08B

http://www.d-ross.org/index.cfm?objectid=9C65ED79-508B-E116-6F81AF8F75FB40AD

Terry Ryan used a lot of this work to create a CFC that you can use:

Re: objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Wed, 08 Jul 2009 16:01:26 GMT

Hmm after passing this value to flex I though it would be a simple piece of data that I could pass back to CF, it turns out to be an array in flex so that makes it not possible to return to coldfusion to check it is the same as a value in the ms sql database.

Re: objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Tue, 07 Jul 2009 14:51:41 GMT

objectGUID in a ms sql databse in a varchar(100) column

forums_noreply@adobe.com — Tue, 07 Jul 2009 12:33:45 GMT

I'm doing

returnAsBinary = "objectGUID"

in a <cfldap> query.

I was thinking of storing this value returned by objectGUID in a ms sql databse in a varchar(100) column as a primary key. Can you see any pitfalls with this method?