Adobe Dreamweaver CC 2015 Bedienungsanleitung PDF herunterladen (Seite 573)

100

101

566

Dynamic sites, pages and web forms

Last updated 6/3/2015

4 Complete the Recordset dialog box for your document type.

For instructions, see the topics below.

5 Click the Test button to execute the query and ensure that it retrieves the information you intended.

If you defined a filter that uses parameters input by users, enter a value in the Test Value box, and click OK. If an

nstance of the recordset is successfully created, a table appears that displays data extracted from the recordset.

6 Click OK to add the recordset to the list of available content sources in the Bindings panel.

Options for the simple Recordset dialog box (PHP, ASP)

1 In the Name box, enter a name for the recordset.

A common practice is to a

dd the prefix rs to recordset names to distinguish them from other object names in the

code, for example: rsPressReleases.

Recordset names can only contain letters, numbers, and the underscore character (_). You cannot use special

cha

racters or spaces.

2 Select a connection from the Connection pop-up menu.

If no connection appears in the l

ist, click Define to create one.

3 In the Table pop-up menu, select the database table that will provide data to the recordset.

The pop-up menu displays all tables in the specified database.

4 To include a subset of the table’s columns in the recordset, click Selected and choose the desired columns by Control-

clicking (Windows) or Command-clicking (Macintosh) them in the list.

5 To further limit the records returned from the table, complete the Filter section:

• From the first pop-up menu, select a column in the database table to compare against a test value you define.

• From the second pop-up menu, select a conditional expression to compare the selected value in each record

against the test value.

• From the third pop-up menu, select Entered Value.

• In the box, enter the test value.

If the specified value in a record meets your filtering condition, the record is included the recordset.

6 (Optional) To sort the records, select a column to sort by, and then specify whether the records should be sorted in

ascending order (1, 2, 3... or A, B, C...) or descending order.

7 Click Test to connect to the database and create an instance of the data source, and click OK to close the data source.

A table appears displaying the returned data. Each row contains a record and each column represents a field in that

cord.

8 Click OK. The newly defined recordset appears in the Bindings panel.

1 2 ... 568 569 570 571 572 573 574 575 576 577 578 ... 699 700

Kommentare zu diesen Handbüchern

Keine Kommentare

Adobe Dreamweaver CC 2015 Bedienungsanleitung Seite 573

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Adobe Dreamweaver CC 2015