Adobe Dreamweaver CC 2015 Manuel d'utilisateur télécharger pdf (Page 575)

100

101

568

Dynamic sites, pages and web forms

Last updated 6/3/2015

Define an advanced recordset by writing SQL

Write your own SQL statements by using the advanced Recordset dialog box, or create a SQL statement by using the

graphical Database Items tree.

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

2 Select Windows > Bindings to display the Bindings panel.

3 In the Bindings panel, click the Plus (+) button and select Recordset (Query) from the pop-up menu.

The advanced Recordset dialog box appears. If you are developing a ColdFusion site, the Recordset dialog box is

slightly different. (If the simple Recordset dialog box appears instead, switch to the advanced Recordset dialog box

by clicking the Advanced button.)

4 Complete the advanced Recordset dialog box.

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, the Test button displays the Test Value dialog box. Enter

a value in the Test Value box and click OK. If an instance of the recordset is successfully created, a table displaying

the data from the recordset appears.

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

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

Define a recordset as a source of dynamic content by writing a custom SQL statement, or by creating a SQL statement

using the graphical Database Items tree.

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

A common practice is to add the prefix rs to recordset names to distinguish them from other object names in the

code. For example: rsPressRelease

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

characters or spaces.

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

3 Enter a SQL statement in the SQL text area or use the graphical Database Items tree at the bottom of the dialog box

to build a SQL statement from the chosen recordset.

Do the following to use the Database Items tree to build the SQL statement:

• Ensure the SQL text area is blank.

• Expand the branches of the tree until you find the database object you need—a column in a table, for example,

or a stored procedure in the database.

• Select the database object and click one of the buttons on the right side of the tree.

For example, if you select a table column, the available buttons are SELECT, WHERE, and ORDER BY. Click one

of the buttons to add the associated clause to your SQL statement.

You can also use a predefined SQL statement in a stored procedure by selecting the stored procedure from the

Database Items tree and clicking the Procedure button. Dreamweaver automatically fills in the SQL and Variable

areas.

1 2 ... 570 571 572 573 574 575 576 577 578 579 580 ... 699 700

Commentaires sur ces manuels

Pas de commentaire

Adobe Dreamweaver CC 2015 Manuel d'utilisateur Page 575

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Adobe Dreamweaver CC 2015