Give this a try:
#Replace(name, "'", "''", "ALL")#
Russel
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
============================================================
> -----Original Message-----
> From: Paul's Mail [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 25, 2001 17:06
> To: CF-Talk
> Subject: Small problem and banning O'Conners
>
>
> I am inserting data from various sources into an Access table using SQL
> Insert Into statement and having a problem with the insert
> stopping when it
> reaches a '#name#' with a hyphen in it eg O'Conner.
> The hyphen is taken as enclosing the text field and so causes the
> statement
> to report a syntax fault.
> Is there any simple work around this besides banning O'Conners etc?
>
> Paul Burgess
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
