Well there is and here is where I took the solution from: http://orangepips.instantspot.com/blog/Database
The funny thing is I found this nearly a year ago and actually commented on the post just forgot all about it.
The result:
Nov 6, 2009
ColdFusion md5 hash directy in MSSQL
Ever needed to compare a ColdFusion hash() directly in MS SQL? I did today and I knew I had accomplished this before but forgot how to do it. Searching the net and twitter I came to some dead end or longish solutions. I knew Steve Good and I worked this out once before but I also remember there being an easier way.
Well there is and here is where I took the solution from: http://orangepips.instantspot.com/blog/Database
The funny thing is I found this nearly a year ago and actually commented on the post just forgot all about it.
The result:
Well there is and here is where I took the solution from: http://orangepips.instantspot.com/blog/Database
The funny thing is I found this nearly a year ago and actually commented on the post just forgot all about it.
The result:
Subscribe to:
Post Comments (Atom)
So given that CF has the ability to create a hash effortlessly, what would be a real world scenario where you would want SQL server doing the hashing?
ReplyDeleteI had a series of string in a table. To gain a little extra performance on selects I have a hash of each string with an index. I needed to get the hash of a string directly in enterprise manger to confirm some entries.
ReplyDelete