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/[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.
>
>
> --------------------------------------------------------------------------
-
> 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/[email protected]/"
eudora="autourl">http://www.mail-archive.com/[email protected]/</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>
>
> --=====================_12476792==_.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.
