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:
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). |