
1180
Part VII
Extending Dreamweaver
6. By default, all the columns are included in the recordset. To specify certain columns,
choose the Selected option and select any desired field. Shift+click to select contiguous col-
umns, and Ctrl+click (Command+click) to select noncontiguous columns.
7. By default, all the records in the selected columns are available. To limit the recordset fur-
ther, use the four Filter drop-down lists as follows:
Choose the field on which you want to base your filter from the first drop-down list.
■■
This list changes dynamically according to which table you’ve selected.
From the second drop-down list, select the expression with which to compare the data
■■
from the selected column in the first drop-down list. Available expressions are =, >, <,
>=, <=, <>, Begins With, Ends With, and Contains.
Choose the type of value to compare to the selected field from the third drop-down list.
■■
Available types are URL Parameter, Form Variable, Cookie, Session Variable, Application
Variable, and Entered Value.
In the fourth input field, enter the value to compare to the selected field. Values entered
■■
are not case-sensitive.
8. To sort the data, select a column from the first drop-down list under Sort and choose either
Ascending or Descending from the second list.
9. At any time, you can see what results will be returned for the recordset by clicking Test.
To see how ...