No Images Added Yet

SQL statements in ASP - beware the apostrophe

Not Rated Yet.
Add to Favorites
How to stop your SQL statements causing errors in ASP when using apostrophes in string values.
Product Details

One of the most common problems encountered in ASP when using SQL statements, is the existence of an apostrophe (i.e. single quotation mark) in an SQL query string. I say problem because SQL Server (or any T-SQL database server) interprets single quotes as the representation of a string value - that is, as delimiters. Therefore to avoid conflict between single quote delimiters and apostrophes we need to let ASP know that we want an actual apostrophe and not the end of the string. My short tutorial will show you let's get started

Report this Listing
Licence Type
Submitted on
15th August 2008
Last Updated
28th January 2009
Licence Type
License Price

You May Also Like

User Reviews

Please rate the listing and tell the world know what do you think about the listing.
(0 ratings)
Not Rated Yet.
No reviews found.
Not yet reviewed by any member. You can be the first one to write a review for this listing.Click hereto submit your review.