• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Using SQL > Getting by Without Learning SQL

Getting by Without Learning SQL

In many cases, it’s possible to work with a SQL database in Dreamweaver without much of a clue as to what is actually happening when your application talks to the database. You do this by using Dreamweaver dialog boxes to define a recordset, which is a snapshot of some portion of the data in your table (Figure 4.1). To find out what the basic procedure is for defining a recordset, see the Using the Data Bindings Panel section in Chapter 2.

Figure 4.1. A recordset is a snapshot of some of the data in your table.


You can also use Dreamweaver to display the data you selected in the recordset using text or tables, by way of the Dynamic Text or Dynamic Tables dialog boxes (Figure 4.2). These are covered in detail in Chapter 5 under Adding Dynamic Text to a Page.

Figure 4.2. You can display a recordset using the Dynamic Text dialog box.


And you can also click your way around to make changes to existing records or add new records, which are covered in Chapter 8, Editing Records from Web Interfaces (Figure 4.3).

Figure 4.3. You can use Dreamweaver to change or add a record.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint