
744
Part IV
Incorporating Dynamic Data
FIGURE 19-11
To work with more than one table or to filter against more than one field, use Dreamweaver’s
advanced Recordset dialog box.
If you’re using Microsoft Access for your database, you can create your query using the
Access Query Builder, switch to SQL View, copy the code, and paste the code directly
into the SQL text area. This is a fast way to create complex join statements, and it can save a lot of
troubleshooting time.
7. Select from the following to use the Database Items point-and-click method:
For the
■■
SELECT clause of the SQL query, expand the Tables section of the tree to pick
the desired table and, under that table, the desired column. With the column selected,
click the SELECT button.
You can only add one column at a time; repeat this step to include additional columns.
■■
For the
■■
WHERE clause of the SQL query, choose the desired column and click the WHERE
button. Complete the clause by entering an operator (such as
=, <, >, or LIKE) and a com-
parative value. The value may be a constant or a variable defined in the Variables area.
For the
■■
ORDER BY clause of the SQL query, choose the desired column and click the
ORDER BY button. Add the keyword
ASC for an ascending sort or DESC for a descend-
ing sort.
8. To include a variable in the SQL statement, click the Add (+) button in the Variables sec-
tion. Enter a name for the ...