Hi,
Should I use this code on the form or the action page?
<CFSET pattern_name = replace(pattern_name, '"', '"', 'all')>
I tried in on both in different places within the code to no avail... I am
lost as to where I should use this code, although I understand (now) what it
does. I need all " symbols to appear as " in my database.
By the way it is not my SQL that is the problem. It is the shopping cart
system that my client uses. It will not allow the " symbol in the name
category, although I can display it as " in the code and it works just
fine.
Still at it,
Mike
> 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?!?
>
>
> -----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?
>
------------------------------------------------------------------------------------------------
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]
