Re: Inserting data that has apostrophes

From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx>
Date: Tue, 21 Feb 2006 10:25:03 -0000

noemail@xxxxxxxxx wrote on Tue, 21 Feb 2006 04:50:44 GMT:

Hello All!

How do I take a form on a web page where someone has entered information
in one of the fields with an apostrophe and make it so it doesn't delimit
my SQL statement and produce an error? Thanks in advance!

Double them up, eg:

UPDATE Table SET Col = 'O''Reilly'

Dan

.

References:
- Inserting data that has apostrophes
  - From: noemail

Prev by Date: Re: DataSet, Stored Procedures and Return Values
Next by Date: Retrieving hyperlink url from Excel spread***
Previous by thread: Inserting data that has apostrophes
Next by thread: Retrieving hyperlink url from Excel spread***
Index(es):
- Date
- Thread