you need to escape the apostrophies with
<cfset vexperience=Replace(#strEXPERIENCE#, "'", "''", "ALL")>
then insert the new field into the query string. I've been fighting this
problem for 6 months and this is the solution that seems to work best.
Preservesinglequotes doesn't work in this instance.
Hope this solves your problem
Bonnie
AGS
-----Original Message-----
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 28, 2000 10:55 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: SQL and apostrophes
--=====================_3684492==_.ALT
Content-Type: text/plain; charset="us-ascii"
I did just that. Now if the field has a double quote in it, it gets cut off
at that point (it looks like the end of the string). :-(
At 04:18 PM 7/28/00 -0400, Jake Hileman wrote:
>Just put it between double quotes. Most datatypes use doublequotes anyhow..
>so it would be
>last_name="O'Brien" and you should be okay.
>
>let me know if i'm retarded or not.. i probably am :-)
>
>jake
>----- Original Message -----
>From: "Peter Theobald" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Friday, July 28, 2000 1:23 PM
>Subject: Re: SQL and apostrophes
>
>
>> --=====================_12476792==_.ALT
>> Content-Type: text/plain; charset="us-ascii"
>>
>> I'm having the same problem.
>>
>> At 04:03 PM 7/27/00 -0600, Nick Call wrote:
>> >Any SQL Server 7 gurus out there that know how to allow apostrophe's in
>SQL
>> >statements? For example, last_name = 'O'Brien' chokes the query.
>> >
>> >TIA.
>> >Nick
>> >
>> >
>>
>>--------------------------------------------------------------------------
-
>---
>> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> >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.
>>
>>
>>
--------------------------------------------------------------------------
>-
>> Peter Theobald, Chief Technology Officer
>> LiquidStreaming http://www.liquidstreaming.com
>> [EMAIL PROTECTED]
>> Phone 1.212.545.1232 Fax 1.212.679.8032
>>
>> --=====================_12476792==_.ALT
>> Content-Type: text/html; charset="us-ascii"
>>
>> <html>
>> <font size=3>I'm having the same problem.<br>
>> <br>
>> At 04:03 PM 7/27/00 -0600, Nick Call wrote:<br>
>> <blockquote type=cite cite>Any SQL Server 7 gurus out there that know how
>> to allow apostrophe's in SQL<br>
>> statements? For example, last_name = 'O'Brien' chokes the
>> query.<br>
>> <br>
>> TIA.<br>
>> Nick<br>
>> <br>
>> <br>
>>
--------------------------------------------------------------------------
>----<br>
>> Archives:
>> <a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
>eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a>
<
>br>
>> To Unsubscribe visit
>> <a
>href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/c
f
>_talk"
>eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&b
o
>dy=lists/cf_talk</a>
>> or send a message to [EMAIL PROTECTED] with 'unsubscribe'
>in the body. </font></blockquote><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>
>>
>> --=====================_12476792==_.ALT--
>>
>>
--------------------------------------------------------------------------
>----
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> 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/cf-talk@houseoffusion.com/
>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.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
--=====================_3684492==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<font size=3>I did just that. Now if the field has a double quote in it,
it gets cut off at that point (it looks like the end of the string).
:-(<br>
<br>
At 04:18 PM 7/28/00 -0400, Jake Hileman wrote:<br>
<blockquote type=cite cite>Just put it between double quotes. Most
datatypes use doublequotes anyhow..<br>
so it would be<br>
last_name="O'Brien" and you should be okay.<br>
<br>
let me know if i'm retarded or not.. i probably am :-)<br>
<br>
jake<br>
----- Original Message -----<br>
From: "Peter Theobald" <[EMAIL PROTECTED]><br>
To: <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]><br>
Sent: Friday, July 28, 2000 1:23 PM<br>
Subject: Re: SQL and apostrophes<br>
<br>
<br>
> --=====================_12476792==_.ALT<br>
> Content-Type: text/plain; charset="us-ascii"<br>
><br>
> I'm having the same problem.<br>
><br>
> At 04:03 PM 7/27/00 -0600, Nick Call wrote:<br>
> >Any SQL Server 7 gurus out there that know how to allow
apostrophe's in<br>
SQL<br>
> >statements? For example, last_name = 'O'Brien' chokes the
query.<br>
> ><br>
> >TIA.<br>
> >Nick<br>
> ><br>
> ><br>
><br>
>------------------------------------------------------------------------
---<br>
---<br>
> >Archives:
<a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><
br>
> >To Unsubscribe visit<br>
<a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk</a>
or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in<br>
the body.<br>
><br>
><br>
>
--------------------------------------------------------------------------<b
r>
-<br>
> Peter Theobald, Chief Technology Officer<br>
> LiquidStreaming <a href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a><br>
> [EMAIL PROTECTED]<br>
> Phone 1.212.545.1232 Fax 1.212.679.8032<br>
><br>
> --=====================_12476792==_.ALT<br>
> Content-Type: text/html; charset="us-ascii"<br>
><br>
> <html><br>
> <font size=3>I'm having the same problem.<br><br>
> <br><br>
> At 04:03 PM 7/27/00 -0600, Nick Call wrote:<br><br>
> <blockquote type=cite cite>Any SQL Server 7 gurus out there that
know how<br>
> to allow apostrophe's in SQL<br><br>
> statements?&nbsp; For example, last_name = 'O'Brien' chokes the<br>
> query.<br><br>
> <br><br>
> TIA.<br><br>
> Nick<br><br>
> <br><br>
> <br><br>
>
--------------------------------------------------------------------------<b
r>
----<br><br>
> Archives:<br>
> <a
href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"<br>
eudora="autourl"><a
href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a>&
lt;/a><<br>
br><br>
> To Unsubscribe visit<br>
> <a<br>
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&amp;body
=lists/cf<br>
_talk"<br>
eudora="autourl"><a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&amp;bo"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&am
p;bo</a><br>
dy=lists/cf_talk</a><br>
> or send a message to [EMAIL PROTECTED] with
'unsubscribe'<br>
in the body. </font></blockquote><br><br>
><br>
> <font size=2><b><br><br>
>
--------------------------------------------------------------------------<b
r>
-<br><br>
> Peter Theobald, </b>Chief Technology Officer<br><br>
> </font><font size=3
color="#0000FF"><b>LiquidStreaming
</b></font><a<br>
href="http://www.liquidstreaming.com/"
eudora="autourl"><font size=2<br>
color="#0000FF"><u><a
href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a></a><br><br>
> </u></font><font
size=2>[EMAIL PROTECTED]<br><br>
> <b>Phone</b> 1.212.545.1232 <b>Fax</b>
1.212.679.8032<br><br>
> </font></html><br>
><br>
> --=====================_12476792==_.ALT--<br>
><br>
>
--------------------------------------------------------------------------<b
r>
----<br>
> Archives: <a
href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><
br>
> To Unsubscribe visit<br>
<a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk</a> or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in<br>
the body.<br>
><br>
<br>
----------------------------------------------------------------------------
--<br>
Archives: <a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><
br>
To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk</a> or send a message to [EMAIL PROTECTED]
with 'unsubscribe' in the body. </font></blockquote><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>
--=====================_3684492==_.ALT--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.