Add records with sql statments ASP / Database Integration
Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Edit records with sql statements ASP / Database Integration
Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
String Functions ASP / Getting Started
This tutorial will teach you all of the basic string functions available in ASP using VBScript. I will keep things concise as possible. The following is a list of the functions and an example of each.
Search db by Field ASP / Database Integration
Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value.
A Text-Based Search Engine ASP / Site Navigation and Searching
Have you wanted to allow your users to search through your website, checking for files that contain a particular string? Using the FileSystemObject, you can search through all of the files in a particular directory that contain a particular string.
Database Search Engine ASP / Site Navigation and Searching
This sample ASP script we will search a custom query in an SQL database. We will use two custom script in one page and will take query results divided in pages.
How to Encrypt String Using MD5 ASP / Security
In classic ASP there is no any encrypt function. But you can use this useful source code to encrypt any string data using MD5. MD5 encryption is a one-way hashing algorithm. MD5 is a great advantage because it is speed and easy to use.
ASP SPLIT, REPLACE and JOIN String Functions ASP / Miscellaneous
The various string functions can be used interchangeably often. We will write the same script using SPLIT, REPLACE and JOIN to demonstrate all 3 functions and how they often are used for similar tasks. However, your programming situations may be especially suited for 1 out of 3 of the functions.
VBScript Functions : The Len() Function ASP / Getting Started
In this series of our ASP Developer Articles, we will examine a new VbScript function called as ' The Len() Function'. With LEN functions you can calculate the length of the string. Following function calculates the length of a string taken from input area.
Encoding URL strings ASP / Getting Started
While passing variables as an URL's querystring, you should need to encode the string. All special characters like space must be written in adress bar in a form for browser.
Caching Data in ASP ASP / Miscellaneous
Do you have a web page that takes a long time to generate? Do you have a SQL query that you want to cache the results? This tutorial will show how to use Application variables to store cached data.