Ok here's what's going on:
I'm using the encrypt() function to encrypt data as it goes into my
database.
Like this:
<cfquery datasource="#application.dsn#" name="insertencrypteddata">
UPDATE mytable
SET myvalue= '#encrypt("#FORM.myvalue#","mykey")#'
WHERE id = #FORM.id"
</cfquery>
Some of you probably already know what my problem is. Sometimes this
works fine. Other times the encrypted values have characters in them
that (like single-quote) that break my query. Anybody been through
this? Solutions?
Thanks in advance
Willy
-----
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
