logo
What's New
What's New
 Popular
Popular
 Top Rated
Top Rated
 Search
Search

Search :  

Home | How to Add Link |  My Account | Sponsor Listing |  Login | Register  | Getting Rated

Sponsers


Buy & Sell Text Link


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

 

 Home  » ASP » Tips and Tutorials » Development


  SQL statements in ASP - beware the apostrophe

Hits: 249



Advertisement
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.


Rating Graph

0.0%
0.0%
0.0%
0.0%
0.0%
 1  2  3  4  5 


Resource Details:
Price :free
Date Added :Sat Aug 30, 2008
Author :George Grubar

Rate:  0.0(out of 5) 
Vote:  0  Votes

Bookmark Resource Google Technorati Stumble Upon Facebook Digg Windows Live Reddit Mixx Twitter Del.icio.us Ma.gnolia Yahoo! MyWeb Furl" BlinkList


Other Listing by This User:
  • Select and Display database records in ASP.NET

  • How to delete database record in ASP - 3 simple steps

  • Build a Drop Down menu using an ASP Recordset



  • Google
      Web AdvanceScripts.com

     
    Home | Feedback | Advertise with us
    (c) Copyright 2006 AdvanceScripts™. All rights reserved.
    No part of this website may be reproduced, copied and/or distributed in any medium without express written permission
    Trademarks are property of their respective owners
    Site Developed and Hosted by Ethic Solutions

    Hosting Resources  Free Tutorials    Flash Tutorials  Webmaster dicussion forum   Web Directory    phpLDHacks    Bollywood Discussion    


    63 users online