FYI, CF doesn't convert single quotes to double quotes. It escapes
single quotes with another single quote. Here's what the help says:
------
Developing Web Applications with ColdFusion | Selecting and Presenting
Data | Using Dynamic Query Parameters
ODBC allows you to denote a single quote inside a quote-delimited string
by using two consecutive single quote characters (''). Since you can't
possibly be expected to do this yourself, ColdFusion automatically
replaces the single quote (') with two single quotes (") before including
parameter values in SQL statements.
In special cases, you might want to suppress automatic escaping of single
quotes. To do this, use the PreserveSingleQuotes function.
------
-David
On Thu, 19 Oct 2000 00:52:25 -0400 "Norman Elton" <[EMAIL PROTECTED]> writes:
> Make sure you are using the PreserveSingleQuotes function around
> any string value. ColdFusion will convert your single quotes to double
> quotes unless you specify otherwise.
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------------------------
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]
