Hi,
try inserting the URLEncodedFormat() of O'Connor. ;-)) With CF4.5 you can
use URLDecode() to re-convert the values when selecting from the table. If
you are using a CF prior to 4.5 you want to check the tag gallery, there is
a Cistom tag for URL decoding.
HTH,
Chris
> -----Urspr�ngliche Nachricht-----
> Von: Paul's Mail [mailto:[EMAIL PROTECTED]]
> Gesendet: Freitag, 26. Januar 2001 00:06
> An: CF-Talk
> Betreff: 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
