Don't know if this is the problem or not, but do not encrypt() or descrypt() WITHIN the query. Do it to a variable outside the query that you then use in the query...
> Hey cf people, > > I'm trying to use the encrypt() and decrypt() functions. I can encrypt ju st > fine but when I try to decrypt it throws an error saying incorrect value. > I'm using the same key and still the error. > > I'm storing a password in the database encrypted and trying to decrypt th e > value from the database to compare with the password supplied. > > It there a trick to uses these functions? > > Shawn Regan > Applications Developer > pacifictechnologysolutions > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
