Use the preserveSingleQuotes() CF function. Regards, Rob Rusher
--- "David D. Droddy" <[EMAIL PROTECTED]> wrote: > This is a multi-part message in MIME format. > > ------=_NextPart_000_0009_01C2B7CD.8347E1A0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > I'm working on INSERT statements in CF5 to an Access Database. Sometimes = > I will be sending strings with apostrophes (the board's decision). I = > tried this for the first time yesterday and got errors. I finaly = > realized that the apostrophe is ending the string. How can I include the = > apostrophe in my SQL strings? > > Thanks > > > David Droddy > American University > Washington College of Law > ------=_NextPart_000_0009_01C2B7CD.8347E1A0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; = > charset=3Diso-8859-1"> > <META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><STRONG><FONT face=3D"MS Sans Serif" size=3D2>I'm working on INSERT = > statements=20 > in CF5 to an Access Database. Sometimes I will be sending strings with=20 > apostrophes (the board's decision). I tried this for the first time = > yesterday=20 > and got errors. I finaly realized that the apostrophe is ending the = > string. How=20 > can I include the apostrophe in my SQL strings?</FONT></STRONG></DIV> > <DIV><STRONG><FONT face=3D"MS Sans Serif" = > size=3D2></FONT></STRONG> </DIV> > <DIV><STRONG><FONT face=3D"MS Sans Serif" = > size=3D2>Thanks</FONT></STRONG></DIV> > <DIV><STRONG><FONT face=3D"MS Sans Serif" = > size=3D2></FONT></STRONG> </DIV> > <DIV><STRONG><FONT face=3D"MS Sans Serif" = > size=3D2></FONT></STRONG> </DIV> > <DIV><STRONG><FONT face=3D"MS Sans Serif" size=3D2>David=20 > Droddy</FONT></STRONG></DIV> > <DIV><STRONG><FONT face=3D"MS Sans Serif" size=3D2>American=20 > University</FONT></STRONG></DIV> > <DIV><STRONG><FONT face=3D"MS Sans Serif" size=3D2>Washington College of = > > Law</FONT></STRONG></DIV></BODY></HTML> > > ------=_NextPart_000_0009_01C2B7CD.8347E1A0-- > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
