Figure 15-2: The Add Bindings panel and its pop-up menu in Java

Creation QR in Java Figure 15-2: The Add Bindings panel and its pop-up menu

The Add Bindings pop-up menu has the following options: Recordset (Query): A recordset stores data from your database for use on a page or set of pages I explain recordsets in more detail later in this chapter Command (Stored Procedure): Commands, or stored procedures, are reusable database items that contain SQL (Structured Query Language)

code and are commonly used to modify a database (insert, update, or delete records) Request Variable: Commonly used wherever a search is involved, a request variable carries information from one page to another When you use a form to submit data to another page, a request variable is created Session Variable: Session variables store and display information for the duration of a user s session (or visit) A different session is created on the server for each user and is kept in use either for a set period of time or until a specific action on the site terminates the session (such as a logging out) Application Variable: Application variables store and display information that must be present for all users and is constant throughout the lifetime of an application These types of variables are commonly used for page counters or date and time counters Application variables are available only for ASP and ColdFusion pages, not for PHP and JSP Spry Data Set: Spry data sets link existing XML files to display with any of the various Spry widgets Get More Data Sources: Use this option to open Dreamweaver Exchange in your browser You can use Exchange to download extensions for Dreamweaver You find instructions for downloading and installing extensions in 10

Server behaviors are server-side scripts that perform some type of action Through the Server Behaviors panel, you can add server-side scripts, such as user authentication and record navigation, to your pages Server behaviors available to you vary depending on the server technology you use You can get to the Server Behaviors panel by choosing Window Server Behaviors You can view the available server behaviors by clicking the plus sign (+) in the Server Behaviors panel to get the Server Behaviors pop-up menu (see Figure 15-3) The Server Behaviors pop-up menu has the following options: Recordset (Query): A recordset stores data from your database for use on a page or set of pages I explain recordsets in more detail later in this chapter Command: Commands are reusable database items that contain SQL code and are commonly used to modify a database (insert, update, or delete records)

Repeat Region: This server object displays multiple records on a page Repeat Region is most commonly used on HTML tables or HTML table rows You can find out more about this behavior later in this chapter Recordset Paging: If you have to display a large number of records and want them to appear a page at a time, this set of behaviors allows you to navigate from page to page or from record to record Show Region: With this set of server behaviors, you can show or hide record navigation based on the records displayed For instance, if you have Next and Previous links on the bottom of every page and your user is on the first page or first record of the recordset, you can set a behavior to display only the Next link The same is true if the user is on the last page or record you can set the behavior to hide the Next link and display only the Previous link Dynamic Text: This option enables you to display information from your recordset anywhere on the page Go to Detail Page: With this behavior, you can link each record in your repeated region to a detail page for that particular record The behavior also tells the detail page which record s information to display Go to Related Page: You can use this behavior to link a particular dynamic page to another page that contains related information, passing the parameters of the first page to the related page