Hashing Data

[BaileyBurger]

Greetings!

I need to store some sensitve dater, so wanted to place it in hash format and
just compare user input to stored data in hash format. But, wondering how I get
the data into hash format to begin with? We use SQL server 7, and I could not
find any functions for converting the data into hash format. I know I could use
CF to querry, convert and re-insert, but this seems to be going against the
whole idea if the data has to be placed into the DB in readable format.

So, how does one import into SQL server into a hash format? TIA!

[Dan Bracuk]

You could always use the cold fusion hash function.

Originally posted by: BaileyBurger
Greetings!

I need to store some sensitve dater, so wanted to place it in hash format and
just compare user input to stored data in hash format. But, wondering how I get
the data into hash format to begin with? We use SQL server 7, and I could not
find any functions for converting the data into hash format. I know I could use
CF to querry, convert and re-insert, but this seems to be going against the
whole idea if the data has to be placed into the DB in readable format.

So, how does one import into SQL server into a hash format? TIA!

[BaileyBurger]

Yes, but thats what I'm trying to avoid. If I'm going to put the data onto a
internet connected SQL server, I'd want it to be in hash format first, and not
have it exposed to use CF to convert it. The question is how does one import
data (from .dbf file) into SQL server and have it convert to a hash format that
CF can compare to while importing?

[philh]

You'll need a script reference in your DTS upload package that passes the
relevant value to a CF page that uses the hash function, and returns the hashed
result. Look into XMLHTTP and CFCs to enable this (e.g. a VBScript using the
XMLHTTP object calls a CFC that returns your hashed value).

HTH,