Thomas Wallace: Lectures and Resources - A collection of website design lectures and resources

Creating a Recordset (Query) in Dreamweaver

In order to proceed with the creation of our web application we will first need to create a recordset. A recordset is essentially a query to a database. The data returned from that query is called a recordset.

Creating a Recordset

  1. Open the dbexample site in Dreamweaver.
  2. Open then email.asp page that we created in the last tutorial.
  3. In the application palette select the Bindings tab and press the “+” button and then Recordset. Recordset
  4. In the Recordset Dialog box:

Recordset

    • name the recordset RSEmail
    • Set the connection to ITLemon_Email
    • The table should be set to StudentEmail
    • Columns select All
    • Filter set to None
    • Sort LastName Ascending
  1. Test the Recordset
  2. Press Ok to close the Recordset Dialog Box
  3. The application palette should now look like this:

Application Pallette