Hi Michael,
If you REALLY want to do it this way, try:
<CFSET pattern_name = replace(pattern_name, '"', '"', 'all')>
You can convert back if you want later:
<CFSET pattern_name = replace(pattern_name, '"', '"', 'all')>
Isn't that ugly?!? If the problem is that your SQL falls over when you are
inserting quotes, then there are probably better ways of escaping the
special characters. This can depend on your flavour of SQL, though,
Have fun,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-----Original Message-----
From: Michael Wilson [mailto:[EMAIL PROTECTED]]
What CF code can I add to my form field or CF Template to have all " symbols
input into that field (or any other for that matter) converted to "
automatically before it is added to the database?
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee. It is confidential and may contain legally privileged
information. No confidentiality or privilege is waived or lost by any
mistaken transmission to you. If you receive this e-mail in error, please
immediately delete it from your system and notify the sender. You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient. The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
