|
Compact & Repair Access Database
|
Other links at ASP > Tutorials > Database-related |
| 1. |
Named Recordsets
|
|
|
This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets.
|
| 3. |
Using MyODBC To Access Your MySQL Database Via ASP
|
|
|
MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.
|
| 4. |
Search db by Field
|
|
|
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. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.
|
| 5. |
Analyzing Duplicate Records
|
|
|
This is the first of the four-part "Advanced SQL Techniques" series, which describes a quick and efficient way to delete duplicate records from a table.
|
|
|
