Trapping Single Quotation Mark

Hi!

I am looking for a way that I can trap the single quotation mark. If an
encoder uses single quotation mark on a textbox field, it always give me an
error because I use single quotes on the SQL statement. Can you help trap
this character not to produce error?

Me
M P [ Do, 24 November 2005 06:27 ] [ ID #1072073 ]
Webserver » microsoft.public.inetserver.asp.db » Trapping Single Quotation Mark

Vorheriges Thema: Data Access Layer
Nächstes Thema: Retrieving both a recordset and output parameters from a Stored Procedure