-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Check out http://www.swynk.com/friends/knight/encryptfunction.asp that talks
about the encrypt() function. Unfortunately, this is a one-way encryption
method, so it's not really useful for your case.
There are also some useful links on how you can embed COM or JAVA to encrypt
your data, again, this is used for one-way encryption, but I'm sure you could
extend it to use PKI or something for encryption and decryption functions.
:)
Joe
> -----Original Message-----
> From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 02, 2000 5:38 PM
> To: CF-Talk
> Subject: SOT: Data Encryption w/ SQL Server 2000
>
>
> Hi Folks,
>
> I'm on a project where the client is using SQL Server 2000
> and wants to use the *database* to encrypt sensitive
> information (e.g. credit card numbers).
>
> Now I know I can find a CF encryption routine to encrypt the
> data before it gets to the database and decrypt it after it's
> read from the db, but I'd like to know if SQL Server 2000 can
> do it instead (client hasn't determined whether or not
> they'll use CF to develop the app).
>
> This is all I was able to find:
> http://msdn.microsoft.com/library/default.asp?URL=/library/psd
k/sql/ad_secur
ity_93u6.htm which suggests the answer is "no" but I thought I'd pose the
question to those who have more experience w/ the app.
TIA,
- - - - Jeanne
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
