I'm trying to insert a record into database that has an apostrophe. When I build the SQL string it generates a syntax error in the INSERT command. How can I insert a record that has an apostrophe in some fields? Author: Ljubomir
Avoiding a Single Quote Error
Information
|
Resource ID
|
:
|
8302
|
|
ASP.NET Version
|
:
|
ASP.NET 1.1
|
|
Software Version
|
:
|
1.0
|
|
Price
|
:
|
$
0
|
|
Today Hits
|
:
|
9
|
|
Total Hits
|
:
|
264
|
|
Scripting Language
|
:
|
VB
|
|
Resource Added
|
:
|
Sep 22,2008
|