Skip to Main Content
Adobe® Dreamweaver® CS4 Bible
book

Adobe® Dreamweaver® CS4 Bible

by Joseph Lowery
March 2009
Beginner to intermediate content levelBeginner to intermediate
1321 pages
46h 24m
English
Wiley
Content preview from Adobe® Dreamweaver® CS4 Bible
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Adobe® Dreamweaver® CS5 Bible

Adobe® Dreamweaver® CS5 Bible

Joseph W. Lowery
Dreamweaver® CS3 Bible

Dreamweaver® CS3 Bible

Joseph W. Lowery

Publisher Resources

ISBN: 9780470382523Purchase book