Adobe Dreamweaver CS3 Uživatelský manuál stáhnout pdf (Strana 563)

100

101

DREAMWEAVER CS3

User Guide

556

4 Click OK to add the recordset to the Bindings panel.

Example: Selecting specific rows from a table and ordering the results

ThefollowingexampleselectstworowsfromtheEmployeestable,andselectsthejobtypeusingavariablethatyou

must define. The results are then ordered by employee name.

SELECT emplNo, emplName

FROM Employees

WHERE emplJob = 'varJob'

ORDER BY emplName

1 Expand the Tables branch to display all of the tables in the selected database; then expand the Employees table to

display the individual table rows.

2 Build the SQL statement as follows:

• Select emplNo, and click the Select button.

• Select emplName, and click the Select button.

• Select emplJob, and click the Where button.

• Select emplName, and click the Order By button.

3 Place the insertion point after WHERE emplJob in the SQL text area and type ='varJob' (include the equal sign).

4 Define the variable 'varJob' by clicking the Plus (+) button in the Variables area and entering the following

values in the Name, Default Value, and Run-Time Value columns:

varJob, CLERK, Request("job").

5 Click OK to add the recordset to the Bindings panel.

Define URL parameters

URL parameters store retrieved information input by users. Before you begin, make sure you pass a form or URL

parameter to the server. After you define the URL variable, you can use its value in the currently selected page.

1 In the Document window, open the page that will use the variable.

2 Select Windows > Bindings to display the Bindings panel.

3 In the Bindings panel, click the Plus (+) button and select one of the following from the pop-up menu:

4 In the URL Variable dialog box, enter the name of the URL variable in the box, and click OK.

The URL variable name is normally the name of the HTML form field or object used to obtain its value.

5 The URL variable appears in the Bindings panel.

Document Types Menu item in Bindings panel for URL variable

ASP Request Variable > Request.QueryString

ColdFusion URL Variable

JSP Request Variable

PHP URL Variable

September 4, 2007

1 2 ... 558 559 560 561 562 563 564 565 566 567 568 ... 737 738

Komentáře k této Příručce

Žádné komentáře

Adobe Dreamweaver CS3 Uživatelský manuál Strana 563

Komentáře k této Příručce

Související produkty a manuály pro Software Adobe Dreamweaver CS3