Defining a recordset
You can define a recordset using either the Dreamweaver simple Recordset dialog box, which lets you easily construct simple SQL statements, or you can use the advanced Recordset dialog box, which lets you write your own SQL statements, or use the graphical Database Items tree to create a SQL statement.
If you are not familiar with writing SQL statements to retrieve information from a database, use the simple Recordset dialog box.
This section covers the following topics:
- Creating a recordset without writing SQL
- Creating an advanced recordset by writing SQL
- Creating SQL queries using the Database Items tree
- Defining a recordset in a ColdFusion component