Try #Replace(var, "'", "''", ALL)#
You'll still have to wrap all your vars with this but it's less than
PreserveSingleQuotes...
Jeff Garza
Web Developer
Spectrum Astro, Inc.
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Jake Hileman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 8:59 AM
To: CF-Talk
Subject: Re: Single Quotes - Double Quotes ARGH!
I'm still waiting for an answer to this question also! :) Don't forget when
you select, you'll have to use it also. :)
Jake
----- Original Message -----
From: "Peter Theobald" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 26, 2000 4:03 PM
Subject: Single Quotes - Double Quotes ARGH!
> --=====================_14561452==_.ALT
> Content-Type: text/plain; charset="us-ascii"
>
> In several CFQUERYs on many pages I am updating several tables. Very often
these text fields have apostrophes or double-quotes in them. If I surround
the fields with single quotes, then CF escapes them by doubling them. They
actually go into the database doubled. If I surround the fields with double
quotes, then CF cuts them off when it sees the first double-quote.
>
> I cant believe my only option is to surround every single field in every
single update on every single page with PreserveSingleQuotes(). That would
be several hundred PreserveSingleQuotes()...
>
> What is the common practice for handling this? The apostrophe is a common
character in English text...
>
>
>
> --------------------------------------------------------------------------
-
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 Fax 1.212.679.8032
>
> --=====================_14561452==_.ALT
> Content-Type: text/html; charset="us-ascii"
>
> <html>
> <font size=3>In several CFQUERYs on many pages I am updating several
> tables. Very often these text fields have apostrophes or double-quotes in
> them. If I surround the fields with single quotes, then CF escapes them
> by doubling them. They actually go into the database doubled. If I
> surround the fields with double quotes, then CF cuts them off when it
> sees the first double-quote.<br>
> <br>
> I cant believe my only option is to surround every single field in every
> single update on every single page with PreserveSingleQuotes(). That
> would be several hundred PreserveSingleQuotes()...<br>
> <br>
> What is the common practice for handling this? The apostrophe is a common
> character in English text...<br>
> <br>
> </font><br>
>
> <font size=2><b><br>
> --------------------------------------------------------------------------
-<br>
> Peter Theobald, </b>Chief Technology Officer<br>
> </font><font size=3 color="#0000FF"><b>LiquidStreaming
> </b></font><a href="http://www.liquidstreaming.com/"
eudora="autourl"><font size=2
color="#0000FF"><u>http://www.liquidstreaming.com</a><br>
> </u></font><font size=2>[EMAIL PROTECTED]<br>
> <b>Phone</b> 1.212.545.1232 <b>Fax</b> 1.212.679.8032<br>
> </font></html>
>
> --=====================_14561452==_.ALT--
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
