Alter a string in an .ASP Page for use in an SQL statement.

Category:

ASP, HTML and XML

Type:

Snippets

Difficulty:

Beginning

Author:

Intelligent Solutions Inc.

Version Compatibility: ASP

More information:

When using strings as values in SQL Statements, you must precede and end the value with single quotes, and replace any single quotes (apostrophe) within the string with an additional quote (e.g., ' must become ''). This function handles all this .

The code for the this task is slightly different for VB6 and .ASP, so see the Database section of this site if you want to do the same thing in VB6.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:
' (None)

Code:

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.