- see footer for list info -<
Tried but it didn't work - same error

Adam Cameron wrote:

- 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.

_______________________________________________

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 -<

Reply via email to