Thanks that did the trick. I guess I'm going to have to clean up my code. I 
just never really used this tag for much unless I was trying to prevent SQL 
injection issues on forward facing pages.

Thanks,
Charlie

On Mar 4, 2011, at 1:29 AM, Alan Williamson <[email protected]> wrote:

> Charlie, you don't have to worry about the encoding if you make sure you use 
> <cfqueryparam value="#form.mytextarea#" />
> 
> more details:
>  http://openbd.org/manual/?/tag/CFQUERYPARAM
> 
> Always good practice to use this
> 
> Matthew Woodward wrote:
>> You have to double up your \ since that's an escape character for MySQL.
>> There's also a mysql_real_escape_string function in MySQL that you can
>> wrap around your input to escape stuff for you.
> 
> -- 
> official tag/function reference: http://openbd.org/manual/
> mailing list - http://groups.google.com/group/openbd?hl=en

-- 
official tag/function reference: http://openbd.org/manual/
 mailing list - http://groups.google.com/group/openbd?hl=en

Reply via email to