tailieunhanh - dreamweaver cs5 all in one for dummies phần 9

Xem Book VII để biết thêm chi tiết về việc thành lập một kết nối cơ sở dữ liệu. Để xác định một recordset đơn giản trong Dreamweaver, hãy làm theo các bước sau: Hãy nhớ sử dụng chữ cái, số, và nhấn mạnh cho tên để chắc chắn rằng tên này tương thích với loại trang năng động của bạn. Trong ví dụ trong hình 1-9, chúng tôi chấp nhận tên mặc định | 682 Using a Database as Your Data Source Before you can define a recordset you need to establish a database connection in Dreamweaver. See Book VII for details on setting up a database connection. To define a simple recordset in Dreamweaver follow these steps 1. Create a new dynamic page or open an existing page. 2. In the Bindings panel click the plus icon and then select Recordset Query in the list that appears. The Recordset dialog box appears. Depending on your dynamic page type the dialog box may look slightly different. If you want to write your own SQL queries for a recordset use the Advanced Recordset dialog box. You can display this version of the dialog box by clicking the Advanced button in the Recordset dialog box. 3. In the Name field enter a name for your recordset. Remember to use only letters numbers and underscores for names to be sure that the name is compatible with your dynamic page type. In the example in Figure 1-9 we accepted the default name Recordset1. Figure 1-9 The Recordset dialog box is set to compare the database column value against the URL parameter. 4. Select a database connection in the Connection drop-down list. In the example we selected the mysql_connection connection. 5. Select the database table in the Table drop-down list. The database table serves as a foundation for retrieving data for a database query. The Columns field updates to display the columns in your selected table. By default all the columns are included in the recordset. In the example shown in Figure 1-9 we chose the footprints table. Using a Database as Your Data Source 683 6. If you want to specify which columns to include select the Selected option and then select the desired columns. If you select the Selected option you can select multiple columns that you want to include in the Columns listing by Ctrl clicking Windows or ô clicking Mac OS X them. 7. Optional If you want to filter the records do the following In the first Filter drop-down list Select a .