 
  |
 |
 Selecting random record from database
|
|
|
|
This ASP source code describes a short way to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database.
Last par
|
|
| |
|
Import text file to MS Access
|
|
|
|
This article will explain how to import the contents of a text file (.txt) to an Access Database when using MS text or OLE DB Drivers wont do! We will be using the FileSystem and TextStream objects in this article!
|
|
| |
|
Make database access safer with transactions
|
|
|
|
You can use transactions in ASP as a kind of insurance policy for your database activities, making them safer and providing better error recovery. Transactions are most useful when doing multiple actions on multiple tables. The example below shows ju
|
|
| |
|
How to connect to database using a connection...
|
|
|
|
The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this t
|
|
| |
|
Counting Records in SQL Script
|
|
|
|
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
|
|
| |
|
How to Encrypt Passwords in the Database
|
|
|
|
If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passw
|
|
| |
|
|
|
