>- see footer for list info -< I'm just coding the password side of a site now. I'm using hash with SHA-384 making the password unrecoverable for security reasons. New passwords issued are randomly generated. SHA-256 and above is very strong and uncracked (so far).
To avoid problems with storing encypted data because of quotes and other risky characters I sometimes use ToBase64(myEncryptedString) which always gives you alphanumeric characters. Use ToString() to convert back. Gary. On 4/8/06, Snake <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > The various encrypt methods that are now available in CFMX7 are pretty > powerful, you have AEN, DES, SHA and more. They are significantly better > than cfusion_encrypt too, which is not especially strong encryption. > Try about the various different methods to find one that that works for > you. > If you don't need to decrypt then one way encryption is best, such as > Hash(). This is perfect for passwords, as you simply generate a new > password > if the user loses it. > > Russ > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Allan Cliff > Sent: 07 April 2006 18:44 > To: Coldfusion Development > Subject: Re: [CF-Dev] Encrypt problem > > >- see footer for list info -< > I second using cfusion_encrypt, which I have used for years > ----- Original Message ----- > From: Duncan Cumming > To: [email protected] > Sent: Friday, April 07, 2006 3:03 PM > Subject: Re: [CF-Dev] Encrypt problem > > > >- see footer for list info -< > try cfusion_encrypt instead. also read this thread here: > > > http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/Threadid:24272# > 122140 > > Duncan Cumming > New Media Developer > Customer Relations Management / Education > Fife Council > 700 4105 / 01592 414105 > > >>> [EMAIL PROTECTED] 07/04/2006 13:57 >>> > >- see footer for list info -< > Hi all, > > how do you insert an encrypted string into a database? > > Example: > > <cfquery name="ins1" datasource="#request.dsn#" > password="#request.pwd#"> > INSERT INTO tbl_example > (name,dob) > VALUES > ('#encrypt(name,"12345")#','#encrypt(dob,"12345")#') > </cfquery> > > The encrypted strings cause a problem with the db query because of the > charaters that are outputted. IE. the above query goes through like this: > > INSERT INTO tbl_example (name,dob) VALUES ('%;E:0MOP ','(# O1[ZQBUO< ') > > Thanks, Damien > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > > > ********************************************************************** > This email and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed > and should not be disclosed to any other party. > If you have received this email in error please notify your system manager > and the sender of this message. > > This email message has been swept for the presence of computer viruses but > no guarantee is given that this e-mail message and any attachments are > free > from viruses. > > Fife Council > Tel: 08451 55 00 00 > ************************************************ > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > >-< > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
