After you encrypt the variable, convert it to base 64 before storing in the
database... unfortunately the function to do this, ToBase64, is only
available in CF 4.5.
To encrypt, use....
<CFSET Pass = ToBase64(Encrypt(Form.Password, "your_crypt_key"))>
and then when comparing later, use...
<CFIF (DeCrypt(ToString(ToBinary(query.Password)), "your_crypt_key') EQ
Form.Password>
HTHAL
Nick
At 08:59 26/05/00 -0400, you wrote:
>I use te function #encryt(var)# to encrypt a variable ...and I store it in
>an access database ..It's working fine but once in a while I get a sql error
>because the string I store contains characters that bugs my sql query
>
>I can I fix it?
>or what caracters should I not use in a query?
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
