[cfaussie] RE: CFLDAP objectGUID

[Taco Fleur]

Title: CFLDAP objectGUID

Its all done by MS SQL now, I'd still like to know the solution to the problem below though if anyone knows one?

 

BTW the code for MS SQL is:

 

SELECT   CAST(AD.objectGUID AS uniqueidentifier) AS objectGUID,
     cn,
     mail,
     samAccountName,
     U.pkIDUser
 FROM   OpenQuery( ADSI,
  'SELECT   objectCategory,
      objectGUID,
      cn,
      mail,
      samAccountName
  FROM   ''LDAP://phobos.tq.com.au/dc=tq,dc=com,dc=au''
  WHERE   samAccountName = ''#arguments.username#'' ') AD
 INNER JOIN   tblTQUser U
 ON     AD.objectGUID = U.objectGUID

 

Taco Fleur
07 3535 5072
Blog: http://www.tacofleur.com/index/blog/
Methodology: http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn

-----Original Message-----
From: Taco Fleur
Sent: Monday, 29 March 2004 12:30 PM
To: CFAussie Mailing List
Subject: [cfaussie] CFLDAP objectGUID

I query LDAP like so;

<cfldap action=""
          name="qUserInfo"
          attributes="cn,mail,objectGUID"
          start="dc=tq,dc=com,dc=au"
          filter="samAccountName=#arguments.username#"
          server="tq.com.au"
          username="TQ\******"
          password="*********"
          rebind="Yes">

When I dump the result I get "u 3tfy]J�A�Է`�
" returned for the objectGUID, when I run the same query through Query Analyzer I know I need to cast the result as a UNIQUEIDENTIFIER, but what do I do with the result from CFLDAP to get 0AB234FC-6358-4331-965F-2F3FC8A70303 ?

I am about to do away with CFLDAP and perform the query within MS SQL, so this is my last resort...

Taco Fleur
07 3535 5072

Tell me and I will forget
Show me and I will remember
Teach me and I will learn

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004