You can enter your SQL directly, copy and paste from a query in Access, or use the
Database Items section to create your queries via point and click.
662
Incorporating Dynamic Data Part IV
To write advanced SQL queries, you can create your queries using the Query Builder in
Microsoft Access or the View Builder in Microsoft SQL. This makes it easy to create complex
joins and filtering in a visual environment. You can then copy and paste the generated SQL directly into the
SQL window in Dreamweaver.
n The third area is used for defining variables to be included in the SQL query. These variables must
be entered into the SQL area manually.
n The area marked Database Items contains an expandable tree of all the data items available
through the currently selected connection, including all tables (and their associated columns),
views (also known as queries in Access), and stored procedures. Next to the tree is a button for
three of the major clauses of a SQL statement: SELECT, WHERE, and ORDER BY.
FIGURE 19-14
To work with more than one table or to filter against more than one field, use Dreamweaver??™s advanced Recordset
dialog box.
To create an advanced recordset, follow these steps:
1. From either the Bindings or the Server Behaviors panel, click the Add (+) button and choose
Recordset (Query) from the drop-down list.
Pages:
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178