if you're using <cfqueryparam>
http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html
----- Original Message -----
From: "Thane Sherrington" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 09, 2004 10:08 AM
Subject: Single quotes, CF5, and MS Access
> To deal with single quotes entered in a comment field, I've been replacing
> them with double quotes, but after doing some reading in the archives, it
> appears that I could avoid this by using CFQueryParam and
> PreserveSingleQuotes. Unforunately, I don't understand exactly how this
> works. If someone would take a minute to show me an example Insert or
> Update query which would handle single quotes in a string field (being
> inserted to a text or memo field), I'd really appreciate it.
>
> T
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
