Categories
ASPTips and Tutorials → Database-related

Get Your Data Faster with a Data Cache

Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 ...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Two Table Join

Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each sta...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Presentation Of Hierarchical Data

Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name &"Hierarchy&" and ac...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Adding Records to a Database using SQL

The purpose of this article is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Connecting To A Database and Retrieving Results in 9 Easy Steps

Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it s hard to separate the database stuff from the rest of the code so I made this ...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

ADO, SQL, and data access tutorial

This is an introductory tutorial on ASP data access. It covers Connection Object, Command Object, and Recordset Object.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Editing and Updating Records in the Database

Complete tutorial on editing and updating records in the database. Each and every step explained in detail for ASP beginners. Both Connection and Recordset Objects discussed.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Adding Records to the Database

This is a complete tutorial on adding records to the database via ASP for beginners. Both Connection and Recordset Objects discussed. Also get an insight on ''insert'' SQL statement.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Page:
©2003-2019 jCay.com