>- see footer for list info -< I presume you've getting problems because the encrypted strings could have single quotes in them, and the DB engine is mistaking them for string delimiters?
I think the problem will simply go away if you use <cfqueryparam> tags. Or wrap the encrypt() call in preserveSingleQuotes() might do the trick, but I'd use <cfqueryparam> tags. -- Adam _______________________________________________ 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 -<
