Quotes
A quote in your SQL statement may cause errors
Example: UPDATE Personnel SET lname='O'hara'
The
'
in O'hara will cause the SQL Statement to error
Replace the
'
with
''
Like so: lname=replace(lname, "
'
", "
''
")
Come learn HTML or Classic ASP in Honolulu, Hawaii!
HOME
|
SQL Tutorials
|
XML Tutorials
|
OKIWEB
|
EMAIL ME
|
ASP Alliance