From the Bindings panel, click
Add (+) and select Recordset (Query) from the list.
3. When the Recordset dialog box opens, make sure you??™re in Simple and not Advanced mode; if
necessary, click Simple.
4. In the Name field, enter rsAgents.
5. From the Connection list, choose RelativeRealty.
6. From the Table list, choose Agents (agents in PHP).
7. Leave the Columns option set to All.
8. From the Sort list, choose agentLastName and Ascending.
9. Click Test to view the chosen data. You should see three records, each with a several columns of
data in alphabetical order by last name.
10. When you??™re done viewing the data, click OK once to close the Test SQL Statement dialog and
again to close the Recordset dialog.
Although this Technique did not result in any dynamic data being placed on the page, recordset
creation is crucial to the development of dynamic applications.
Defining a Recordset
Summary
Although some Web applications don??™t use a data source, the vast majority do. Dreamweaver enables you to
connect to any data source for which you have a driver through a variety of methods, ranging from the simplest
to the most robust. With a connection established, setting up a recordset is the essential next step.
Only after a recordset has been created can you place data on a Dreamweaver page.
Pages:
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186