Database Connectivity - Recordsets/Queries

A recordset acts as your connection between your page and the database server, containing information relating to data handling, including the specification of an SQL statement.

To Create a Recordset: Choose "Create Recordset" on the Database CCP.

When creating a recordset, you must first create a database connection, which stores common information such as database server names or usernames. By choosing a "connection" in the recordset creation stage, you have all this information predefined and filled in for you.

You will have to set the following options, in addition to choosing a connection:

  • A table name from your database.
  • An Structured Query Language statement.
  • An application server type.

Your table name is filled in based upon the table you specify in the "Connection" options, or you can select a different table. Using SQL is the next step, using a statement of your choice.

Your application server type can be selected from ASP (ADO), ColdFusion (ODBC) or PHP (MySQL).