Define url parameters – Adobe Dreamweaver CS3 User Manual
Page 563
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
The following example selects two rows from the Employees table, and selects the job type using a variable that you
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