|
Display Table on Web Page
|
Other links at ASP > Tutorials > Database-related |
| 1. |
Limit query results with the Recordset object
|
|
|
Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.
|
| 2. |
SQL In Simple English - Part II
|
|
|
This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.
|
| 3. |
Randomizing a Recordset
|
|
|
This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling records with certain attributes to the top of an otherwise randomized list.
|
| 4. |
An Easy Way Delete A Record
|
|
|
Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.
|
| 5. |
How to create a System DSN for Access database
|
|
|
You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.
|
|
|
