The net's largest PHP, CGI, Perl, JavaScript and ASP script collection and resource web portal
  New Listings
New Listings
Most Popular
Most Popular
Top Rated
Top Rated
Discussion
Discussion
Link to Us!
Link To Us
Search For:         
   
 
Categories

Ajax
ASP
ASP.NET
C and C++
CFML
CGI and Perl
Flash
Java
JavaScript
PHP
Python
Remotely Hosted
Ruby on Rails
Tools and Utilities
Web Hosting
XML

Sponsor Links



Home :: ASP :: Tips and Tutorials :: Development Notes 

SQL statements in ASP - beware the apostrophe Hits: 145


Description:
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 how.....so let's get started


 Resource Specification
Platform(s): windows
Date Added: Aug 15, 2008
Last Updated: Aug 15, 2008
Author: George Grubar


 Share


 License Information
License # 1:
  License Type: Freeware Price: Free


Average Visitor Rating:     0.00 (out of 5)
Number of Ratings: Votes


  Visitor Voting Booth

Average Member Rating: Not yet reviewed by any member....

You can be the FIRST one to write a review for SQL statements in ASP - beware the apostrophe.

 Other Links by This Member






 

Register | FAQ/Support | Contact Us | About Us | Getting Rated | Link to Us | Bookmark Us | Advertising Info | Terms of Use | Privacy Policy
Copyright © 2009 iNET Interactive. All rights reserved.
Other iNET Interactive Sites:
Web Hosting Talk | dBForums | Mac Forums | Hosting Catalog