Skip to main content
nikos101
nikos101
Inspiring
July 7, 2009
Question

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

  • July 7, 2009
  • 1 reply
  • 2774 views

HI

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?

This topic has been closed for replies.

1 reply

nikos101
nikos101Author
Inspiring
July 7, 2009

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.

nikos101
nikos101Author
Inspiring
July 8, 2009

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.

nikos101
nikos101Author
Inspiring
July 10, 2009

This is the magic code:

<cfset results.objectGUID = binaryencode(results.objectGUID,"HEX")>


Does anyone know how to do the reverse of

<cfset results.objectGUID = binaryencode(results.objectGUID,"HEX")>

so that you can use the objectGUID in the

<cfldap filter

?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices