In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.

Step-by-step tutorial on how to display uploaded binary files from the database using plain ASP pages. Every step has been explained in detail. Downloadable source code available.

It is an often problem with database intergration when you use a reserved word. Often asked why a script does not work and it quite often comes down the the author setting a field name as a reserved word, confusing SQL and making debugging hard. To solve this problem here is a quick list of the SQL Reserved Words.

Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.

SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn't tell you where the error is. This tutorial provides a nice summary of SQL statements.

This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.

You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!

Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database connections with some common database software (Oracle, MySQL, MS Access,MS SQL Server).

This writing will discuss several things to do to ensure the application migration carried on in a good way, particularly for ASP Database applications and to overcome possible problems might occurred. Basically, migrating ASP to Linux means you have to convert to database supported by Linux platforms. Currently, Chili!Soft ASP is already supporting MS Access but not all web hosting companies install this feature. They prefer to use more common database in Linux such as MySQL and PostgreSQL. Pay attention to some Chili!Soft specific ADO methods and properties, since there are slight differences with IIS ASP. You might need to convert some codes in your applications to make it run in Chili!Soft ASP.

Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse these DSNs and thus, with some modifications, use the same DSN for as many database connections.