Dreamweaver Basics Welcome to Dreamweaver What's new in Dreamweaver MX 2004 Streamlined design and development interface Modernized page layout and design environment Powerful and open coding environment Where to start Web-design novices Experienced web designers Experienced hand-coders Web application developers Dreamweaver workflow for creating websites Planning your site Managing your site files Laying out web pages Adding content to pages Hand-coding Setting up a web application Creating dynamic pages Rapid application development Using Dreamweaver with other applications Dreamweaver and accessibility The Dreamweaver accessibility validation feature Guide to Dreamweaver instructional media Dreamweaver Help systems Macromedia website resources Additional books and training Typographical conventions HTML and web technologies resources Exploring the Workspace About the Dreamweaver workspace The workspace layout Dreamweaver workspace elements The Document window The Document toolbar The Standard toolbar The status bar The Insert bar Reports in Dreamweaver About customizing Dreamweaver in multiuser systems Working in the Document window Switching between views in the Document window Resizing the Document window Setting Status Bar preferences Using toolbars, inspectors, and context menus Displaying toolbars Using the Insert bar Displaying the Insert bar and its categories and menus Using the Insert bar to insert objects Customizing and using the Favorites category in the Insert bar Using the Property inspector Using context menus Using panels and panel groups Viewing panels and panel groups Docking and undocking panels and panel groups Resizing and renaming panel groups Setting Panels preferences Using Dreamweaver accessibility features Using screen readers with Dreamweaver Support for operating system accessibility features (Windows only) Using the keyboard to navigate Dreamweaver Navigating panels Navigating the Property inspector Navigating dialog boxes Navigating frames Navigating tables Optimizing the workspace for accessible page design Using visual guides in Dreamweaver Dreamweaver customizing basics Choosing the workspace layout (Windows only) Hiding and displaying the Start page Setting General preferences for Dreamweaver Setting Fonts preferences for Dreamweaver display Customizing keyboard shortcuts Adding extensions to Dreamweaver Reference Setting Fonts preferences Setting General preferences Setting Highlighting preferences Setting Panels preferences Setting Status Bar preferences Setting the Customize Favorite Objects dialog box options Setting the Rename Panel Group dialog box options Setting the Acronym or Abbreviation dialog box options Setting Accessibility preferences Setting the Keyboard Shortcuts dialog box options Setting Dreamweaver preferences Setting Up a Dreamweaver Site About Dreamweaver sites Understanding local and remote folder structure Setting up a new Dreamweaver site Using the Advanced settings to set up a Dreamweaver site Setting up a local folder Setting up a remote folder Troubleshooting the remote folder setup Editing settings for a Dreamweaver site Editing existing websites in Dreamweaver Editing an existing local website in Dreamweaver Editing an existing remote website in Dreamweaver Reference Setting the Site Definition Wizard Editing Files options Setting the Site Definition Wizard Editing Files options Setting the Site Definition Wizard Editing Files options Setting the Site Definition Wizard Testing Files options Setting local/network access options for testing Setting FTP access options for testing Setting RDS access options for testing Setting the Site Definition Wizard Testing Files options Setting the Site Definition Wizard Sharing Files options Setting the Site Definition Wizard Sharing Files options Setting local/network options for remote access Setting FTP options for remote access Setting the Site Definition Wizard Sharing Files options Site Definition Wizard Summary options Setting Local Info category options Setting Remote Info category options Related topics Setting Remote options for Local/Network access Setting Remote options for FTP access Setting up RDS access Setting up SourceSafe database access Setting up WebDAV access Using the Manage Sites dialog box options Creating and Opening Documents Creating new documents Creating a new blank document Creating a document based on a Dreamweaver design file Creating a document based on an existing template Saving a new document Setting a default new document type Opening existing documents Importing a Microsoft Word HTML file Reference Setting the New Document dialog box options Setting options in the General tab of the New Document dialog box Setting options in the Templates tab of the New Document dialog box Setting options in the New Document Preferences dialog box Setting options for the Clean Up Word HTML dialog box Working with Dreamweaver Sites Managing Your Files About site management The Check In/Check Out system Site cloaking Design Notes Accessing sites, a server, and local drives Setting up Dreamweaver to work without defining a site Viewing files and folders Customizing the file and folder details displayed in the expanded Files panel Managing files and folders in the Files panel Setting preferences for the Files panel Working with files in the Files panel Finding files in your Dreamweaver site Working with a visual map of your site Viewing a site map Modifying the site map layout Working with pages in the site map Showing and hiding site map files Viewing the site from a branch Saving the site map Importing and exporting sites Removing a Dreamweaver site from your list of sites Checking in and checking out files Setting up the Check In/Check Out system Checking files into and out of a remote folder Undoing a file check-out Getting and putting files to and from your server Getting files from a remote server Putting files on a remote server Synchronizing the files on your local and remote sites Cloaking folders and files in your site Enabling and disabling site cloaking Cloaking and uncloaking site folders Cloaking and uncloaking specific file types Uncloaking all folders and files Storing file information in Design Notes Enabling and disabling Design Notes for a site Associating Design Notes with files Working with Design Notes Testing your site Site testing guidelines Using reports to test your site Reference Setting the Configure Server dialog box options Setting the Configure Server dialog box options for FTP Setting the Configure Server dialog box options for RDS Using the Files panel Setting Site preference options Setting File View Columns category options Setting Select Recently Modified dialog box options Setting Site Map Layout category options Setting Check In/Out options Setting Synchronize Files dialog box options Setting the Design Notes category options Setting the Design Notes dialog box options Setting Cloaking category options Setting Reports dialog box options Setting Recently Modified dialog box options Managing Site Assets and Libraries About library items Related topics Working with assets Viewing assets in the Assets panel Refreshing the Assets panel Adding an asset to a document Applying a color to text using the Assets panel Applying a URL to an image or text using the Assets panel Selecting and editing assets Reusing assets in another site Creating and managing a list of favorite assets Adding assets to and removing assets from the Favorites list Creating a nickname for a favorite asset Grouping assets in a Favorites folder Working with library items Creating a library item Inserting a library item in a document Editing a library item Setting library highlighting preferences Editing the properties for a library item Making library items editable in a document Editing a behavior in a library item Reference Using the Assets panel Setting Library item properties Managing Contribute Sites with Dreamweaver About managing Contribute sites Site structure and page design for a Contribute site Site connection for Contribute compatibility File transfer to or from a Contribute site Contribute file and folder permissions on the server Contribute special files Preparing a site for use with Contribute Administering a Contribute site using Dreamweaver Troubleshooting a Contribute site Troubleshooting connection problems for a Contribute site Troubleshooting the Contribute administration tools Managing Contribute files using Dreamweaver Deleting, moving, or renaming a remote file in a Contribute site Enabling Contribute users to access templates without root folder access Unlocking a file in a Contribute site Reference Setting options for the Contribute category in the Manage Sites dialog box Laying Out Pages Laying Out Pages with CSS About layers in Dreamweaver Understanding layers HTML code for layers Inserting content blocks for layout Changing highlight color for content blocks Working with content blocks for layout Inserting a layer Nesting layers Setting layer preferences and properties Setting layer preferences Viewing and setting properties for a single layer Viewing and setting properties for multiple layers Managing layers Using the Layers panel Selecting layers Changing the stacking order of layers Changing layer visibility Manipulating layers Resizing layers Moving layers Aligning layers Converting layers to tables Preventing layer overlaps Converting between layers and tables Using rulers and grids to lay out pages Using a tracing image Reference Setting the Insert Div Tag dialog box options Setting the Layers Preferences dialog box options Setting layer properties Setting properties for multiple layers Setting the Convert Layers to Table dialog box options Setting the Convert Tables to Layers dialog box options Setting the Grid Settings dialog box options Presenting Content with Tables About tables Table formatting precedence in HTML About splitting and merging table cells Inserting a table and adding content Importing and exporting tabular data Selecting table elements Selecting a table Selecting rows or columns Selecting cells Using Expanded Tables mode for easier table editing Formatting tables and cells Viewing and setting table, cell, row, and column properties Editing accessibility attributes for a table Using a design scheme to format a table Resizing tables, columns, and rows Resizing a table Resizing columns and rows Making column widths in code consistent with visual widths Clearing set widths and heights Displaying table and column widths and menus Adding and removing rows and columns Splitting and merging cells Copying, pasting, and deleting cells Nesting tables Sorting tables Reference Setting the Insert Table dialog box options Setting the Import Tabular Data dialog box options Setting table properties Setting cell, row, and column properties Setting the Format Table dialog box options Setting the Insert Rows or Columns dialog box options Setting the Split Cell dialog box options Setting the Sort Table dialog box options Setting the Export Table dialog box options Laying Out Pages in Layout Mode About Layout mode About viewing table and cell widths in Layout mode Layout table and cells grid lines Fixed column width and autostretch columns Spacer images Switching from Standard to Layout mode Drawing in Layout mode Drawing layout cells and tables Drawing a nested layout table Adding content to a layout cell Clearing automatically set cell heights Resizing and moving layout cells and tables Resizing and moving layout cells Resizing and moving layout tables Formatting layout cells and tables Formatting layout cells Formatting layout tables Setting column width Making a column autostretch or fixed-width Using spacer images Making column widths in code consistent with visual widths Setting preferences for Layout mode Reference Setting layout cell properties Setting layout table properties Setting the Choose Spacer Image dialog box options Setting the Layout Mode Preferences dialog box options Using Frames About frames and framesets Understanding how frames and framesets work Deciding whether to use frames Understanding nested framesets Working with framesets in the Document window Creating frames and framesets Using a predefined frameset Designing a frameset Selecting frames and framesets Selecting frames and framesets in the Frames panel Selecting frames and framesets in the Document window Opening a document in a frame Saving frame and frameset files Viewing and setting frame properties and attributes Viewing and setting frameset properties Controlling frame content with links Handling browsers that can't display frames Using JavaScript behaviors with frames Reference Setting frame Property inspector options Setting frameset Property inspector options Setting the Frame Tag Accessibility Attributes dialog box options Managing Templates About Dreamweaver templates Types of template regions Templates and template-based documents in Design and Code views Viewing templates in Design view Viewing templates in Code view Viewing template-based documents in Design view Viewing template-based documents in Code view Template tag syntax General syntax rules Template tags Instance tags Links in templates Nested templates Server scripts in templates and template-based documents Template parameters Template expressions The template expression language The Multiple If condition in template code Creating a Dreamweaver template Customizing code coloring preferences for a template Setting highlighting preferences for template regions Creating templates for a Contribute site Creating editable regions Inserting an editable region Selecting editable regions Removing an editable region Changing an editable region's name Creating repeating regions Creating a repeating region in a template Inserting a repeating table Setting alternating background colors in a repeating table Using optional regions Inserting an optional region Modifying an optional region Defining editable tag attributes Specifying editable tag attributes in a template Making an editable tag attribute uneditable Creating a nested template Editing and updating templates Opening a template for editing Manually updating documents that are based on templates Updating templates in a Contribute site Checking template syntax Managing templates Exporting and importing template XML content Exporting a site without template markup Applying or removing a template from an existing document Applying a template to an existing document Detaching a document from a template Editing content in a template-based document Modifying template properties Adding, deleting, and changing the order of a repeating region entry Reference Setting the Save As Template dialog box options Setting the New Editable Region dialog box options Setting the New Repeating Region dialog box options Setting the Insert Repeating Table dialog box options Setting the Optional Region dialog box options Resolving inconsistent region names Setting options for the Editable Tag Attributes dialog box Using the Assets panel to manage templates Setting options for the Update Pages dialog box Setting the Export Template Data as XML dialog box Setting options for the Export Site Without Template Markup dialog box Adding Content to Pages Working with Pages About working with pages About setting page properties About the History panel About web-safe colors Understanding document encoding About using saved commands versus playing back steps Saving web pages Specifying HTML instead of CSS Setting page properties Changing the document title Setting CSS link underline styles Working with colors Defining default text colors Selecting elements in the Document window Showing and hiding invisible elements Using the History panel Automating tasks Repeating steps Applying steps to another object Applying steps to multiple objects Copying and pasting steps between documents Creating new commands from history steps Recording commands Using JavaScript behaviors to detect browsers and plug-ins Previewing and testing pages in browsers Setting download time and size preferences Reference Setting the Title/Encoding Page Properties options Setting the HTML Appearance Page Properties options Setting the CSS Appearance Page Properties options Setting the CSS Links Page Properties options Setting the CSS Headings Page Properties options Setting Tracing Image Page Properties options Setting Invisible Elements preferences Setting the Preview in Browser Preferences options Inserting and Formatting Text About text formatting in Dreamweaver About inserting text About formatting text About conflicting CSS styles Shorthand CSS properties The Property inspector and text formatting The Relevant CSS tab The CSS Properties tab Inserting text Adding text to a document Importing tabular data documents Copying and pasting text from MS Office documents Formatting paragraphs and document structure Formatting paragraphs Aligning text Indenting text Adding paragraph spacing Using horizontal rules Creating bulleted and numbered lists Formatting text Setting and changing fonts and styles Renaming a style Modifying font combinations Changing the text color Inserting dates Inserting special characters Adding space between characters Using Cascading Style Sheets styles Using the CSS Styles panel Using the Relevant CSS tab Using the CSS Properties tab Creating a new CSS style Applying a Class style Exporting styles to create a CSS style sheet Linking to or importing an external CSS style sheet Using the sample Dreamweaver style sheets Editing a CSS style Editing a CSS style sheet Updating CSS style sheets in a Contribute site Using Design-Time style sheets Checking spelling Searching for and replacing text Reference Setting text property options Setting List Properties dialog box options Setting CSS Styles preferences Renaming a style Defining CSS type properties Defining CSS style background properties Defining CSS style block properties Defining CSS style box properties Defining CSS style border properties Defining CSS style list properties Defining CSS style positioning properties Defining CSS style extension properties Setting the Edit Style Sheet dialog box options Setting spelling options Setting the Find and Replace dialog box options Setting the Find and Replace dialog box options for a specific tag search Setting the Find and Replace dialog box options for an advanced text search Setting the Search panel options Inserting Images About images Editing images in Dreamweaver Inserting an image Inserting an image placeholder Aligning an image Resizing an image Cropping an image Optimizing an image using Fireworks Adjusting the brightness and contrast of an image Sharpening an image Creating a rollover image Using an external image editor Applying behaviors to images Reference Setting image properties Setting the Image Tag Accessibility Attributes dialog box options Completing the Image Placeholder dialog box Setting image placeholder properties Setting external image editor preferences Setting the Image Rollover dialog box options Setting the Brightness and Contrast dialog box options Setting the Sharpen Image dialog box options Linking and Navigation Understanding document locations and paths Absolute paths Document-relative paths Jump menus Navigation bars About image maps Creating links Linking files and documents Linking to documents using the Property inspector Linking documents using the Point-to-File icon Linking documents using the site map Using the Hyperlink command Linking to a specific place in a document Managing links Changing a link sitewide Inserting jump menus Using navigation bars Using image maps Attaching JavaScript behaviors to links Checking for broken, external, and orphaned links Fixing broken links Opening linked documents in Dreamweaver Reference Setting the Named Anchor option Setting hyperlink options Setting E-mail Link options Setting the Change Link Sitewide options Setting Insert Jump Menu options Setting Navigation Bar options Setting the Hotspot Property inspector options Working with Other Applications About Fireworks and Flash integration Optimizing your work environment for Fireworks and Flash Working with Fireworks Inserting a Fireworks image Editing a Fireworks image or table from Dreamweaver Optimizing a Fireworks image from Dreamweaver Using Fireworks to modify Dreamweaver image placeholders Specifying launch-and-edit preferences for Fireworks source files Working with Flash Editing Flash content in Dreamweaver Adding Audio, Video, and Interactive Elements About media files Flash file types Audio file formats Inserting and editing media objects Editing accessibility attributes for media objects Starting an external editor for media files Specifying the editor to start from Dreamweaver Using Design Notes with media objects Inserting and modifying a Flash button object Creating and inserting a Flash button Modifying a Flash button object Playing a Flash button object in the document Inserting a Flash text object Inserting Flash content Downloading and installing Flash elements Inserting Flash elements Editing Flash element attributes Inserting Shockwave movies Adding video Adding sound to a page Embedding a sound file Inserting Netscape Navigator plug-in content Inserting plug-in content in your page Playing plug-ins in the Document window Troubleshooting Netscape Navigator plug-ins Inserting an ActiveX control Inserting a Java applet Using behaviors to control media Reference Setting Flash object properties Using parameters to control media objects Setting Flash and Shockwave movie properties Setting Netscape Navigator plug-in properties Setting ActiveX properties Setting Java applet properties Setting the Object Tag Accessibility Attributes dialog box options Setting the Insert Flash Button dialog box options Setting the Flash element inspector Setting the Flash element Edit Array dialog box options Using JavaScript Behaviors Using the Behaviors panel About events Applying a behavior Attaching a behavior to text Changing a behavior Updating a behavior Creating new actions Downloading and installing third-party behaviors Using the behavior actions that come with Dreamweaver Call JavaScript Change Property Check Browser Check Plugin Control Shockwave or Flash Drag Layer Gathering information about the draggable layer Go to URL Jump Menu Jump Menu Go Open Browser Window Play Sound Popup Message Preload Images Set Nav Bar Image Set Text of Frame Set Text of Layer Set Text of Status Bar Set Text of Text Field Show-Hide Layers Show Pop-Up Menu Adding, removing, and changing the order of pop-up menu items Setting the appearance of a pop-up menu Setting advanced appearance options Setting a pop-up menu's position in a document Modifying a pop-up menu Swap Image Swap Image Restore Validate Form Reference Setting the Behaviors panel options Working with Page Code Setting Up Your Coding Environment Viewing your code Using the coder-oriented workspace (Windows only) Setting viewing preferences Setting coding preferences Setting code formatting preferences Applying new formatting preferences to existing documents Setting code hints preferences Setting code rewriting preferences Setting code coloring preferences Customizing keyboard shortcuts Opening files in Code view by default Setting Validator preferences Managing tag libraries Opening and closing the Tag Library editor Adding libraries, tags, and attributes Editing libraries, tags, and attributes Deleting libraries, tags, and attributes Importing custom tags into Dreamweaver Importing tags from XML files Importing custom ASP.NET tags Importing JSP tags from a file Importing JSP tags from a server (web.xml) Importing JRun tags Using an external HTML editor with Dreamweaver Using an integrated HTML editor Using HomeSite (Windows only) Using BBEdit (Macintosh only) Setting file type and external editor preferences Reference Setting the Tag Library editor dialog box options Setting code-viewing options Setting the code format preference options Setting the code hints preference options Setting the code rewriting preference options Setting the code coloring preference options Setting the Validator preference options Setting the New Tags dialog box options Setting the New Attributes dialog box options Setting the JSP tag library Import from File dialog box options Setting the JSP tag library Import from Server dialog box options Setting the Import JRun Server Tags from Folder dialog box options Setting the File Types/Editors preference options Coding in Dreamweaver About coding in Dreamweaver Supported languages Fixing invalid markup Automatic code modification in Dreamweaver About the XHTML code generated by Dreamweaver Server-side includes Regular expressions About server behavior code Writing and editing code Using code hints Working with code snippets Inserting code quickly with the Insert bar Inserting tags with the Tag Chooser Editing tags with Tag editors Indenting code blocks Copying and pasting code Inserting HTML comments Searching and replacing tags and attributes Searching for tags, attributes, or text contained in specific tags Saving search patterns Making quick changes to a code selection Using language-reference material Printing your code Reference Setting the Snippets panel options Setting the Comment dialog box options Setting the Comment Property inspector options Setting the Tag Chooser dialog box options Optimizing and Debugging Your Code Cleaning up your code Verifying that tags and braces are balanced Checking for browser compatibility Validating your tags Making pages XHTML-compliant Using the ColdFusion debugger (Windows only) Reference Setting the Clean Up HTML dialog box options Editing Code in Design View Editing code with the Property inspector Changing attributes with the Tag inspector Editing code with the Quick Tag Editor Inserting an HTML tag with the Quick Tag Editor Editing an HTML tag with the Quick Tag Editor Applying HTML to a selection with the Quick Tag Editor Using the hints menu Editing code with the tag selector Editing scripts Writing a client-side script in Design view Linking to an external script file Editing a script in Design view Working with server-side includes Inserting a server-side include Editing the contents of a server-side include Using JavaScript behaviors Viewing and editing head content Reference Setting the Quick Tag Editor options Setting Quick Tag Editor preferences Setting the Script dialog box options Setting the Script Properties dialog box options Setting the script Property inspector options Setting the server-side include Property inspector options Setting the ColdFusion tag Property inspector options Setting the ASP script Property inspector options Setting Meta properties Setting Title properties Setting Keywords properties Setting Description properties Setting Refresh properties Setting Base properties Setting properties for the link tag Setting code properties Preparing to Build Dynamic Sites Setting Up a Web Application What you need to build web applications Setting up a web server Setting up an application server Choosing your application server Installing a ColdFusion application server Installing an ASP.NET application server Installing an ASP application server Installing a JSP application server Installing a PHP application server Creating a root folder for the application Defining a Dreamweaver site Defining a local folder Defining a remote folder Specifying where dynamic pages can be processed Connecting to a database Reference Setting the Testing Server category options Setting the URL prefix Database Connections for ColdFusion Developers Connecting to a database Creating a ColdFusion data source Connecting to the database in Dreamweaver Editing or deleting a database connection Database Connections for ASP.NET Developers Connecting to a database Obtaining an OLE DB provider for your database Creating an ASP.NET database connection in Dreamweaver Creating a connection using Data Link Properties Sample OLE DB connection parameters for ASP.NET Editing or deleting a database connection Reference Setting the OLE DB Connection dialog box options Setting the Connection String Template dialog box options Setting the SQL Server Connection dialog box options Database Connections for ASP Developers About database connections in ASP ASP database connections OLE DB connections Creating a DSN connection Creating a connection using a local DSN Creating a DSN-less connection Connecting to a database on an ISP Understanding physical and virtual paths Finding a file's physical path with the virtual path Using a virtual path to connect to a database Editing or deleting a database connection Reference Setting the Data Source Name (DSN) dialog box options Setting the Select ODBC DSN dialog box options Setting the Custom Connection String dialog box options Setting the Connection String option Setting the Connections dialog box options Database Connections for JSP Developers About database connections in JSP JSP connections JDBC connection parameters Connecting to a database Connecting through an ODBC driver Editing or deleting a database connection Reference Database Connections for PHP Developers Connecting to a database Editing or deleting a database connection Reference Setting the MySQL Connection dialog box options Setting the Select Database dialog box options Troubleshooting Database Connections Troubleshooting permissions problems Troubleshooting Microsoft error messages 80004005--Data source name not found and no default driver specified 80004005--Couldn't use '(unknown)'; file already in use 80004005--Logon Failed() 80004005--Operation must use an updateable query 80040e07--Data type mismatch in criteria expression 80040e10--Too few parameters 80040e10--COUNT field incorrect 80040e14--Syntax error in INSERT INTO statement 80040e21--ODBC error on Insert or Update 800a0bcd--Either BOF or EOF is true Making Pages Dynamic Optimizing the Workspace for Visual Development Displaying web-application development panels Viewing your database within Dreamweaver Viewing live data in Design view Requirements for displaying live data Copying dependent files Refreshing the page Working in Design view without live data Previewing dynamic pages in a browser Restricting database information displayed in Dreamweaver Reference Setting the Bindings panel options Setting the Server Behaviors panel options Setting the Databases panel options Setting the Components panel options Setting the Live Data Settings dialog box options Setting the Restrict dialog box options The Workflow for Dynamic Page Design Designing the page Creating a source of dynamic content Adding dynamic content to a web page Enhancing the functionality of a dynamic page Adding server behaviors to a page Testing and debugging the page Testing dynamic content Editing dynamic content on a page Deleting dynamic content Obtaining Data for Your Page Using a database to store content Accessing data stored in a database Collecting data submitted by users Form parameters URL parameters Creating URL parameters using HTML links Retrieving form and URL parameters Accessing data stored in session variables Understanding session variables Collecting information to store in session variables Storing URL parameters in session variables Storing form parameters in session variables Storing information in session variables Example of information stored in session variables Retrieving data from session variables Defining Sources of Dynamic Content About dynamic content sources Understanding recordsets Understanding URL and form parameters About session variables ASP and ColdFusion application variables ASP server variables ColdFusion server variables JavaBeans and JSP Defining a recordset Creating a recordset without writing SQL Creating an advanced recordset by writing SQL Creating SQL queries using the Database Items tree Selecting a table Selecting specific rows from a table and ordering the results Defining URL parameters Defining form parameters Defining session variables Defining application variables for ASP and ColdFusion Using a variable as a data source for a ColdFusion recordset Defining server variables Defining ASP server variables Defining ColdFusion server variables Defining PHP server variables Defining JSP server variables Defining JavaBeans (JSP only) Caching content sources Changing or deleting content sources Copying a recordset from one page to another page Reference Setting the Bindings panel options Setting the simple Recordset dialog box options Setting the simple Recordset dialog box options (ColdFusion) Setting the simple DataSet dialog box options (ASP.NET) Setting the advanced Recordset dialog box Setting the advanced Recordset dialog box (ASP.NET) Setting the advanced Recordset dialog box options (ColdFusion) Setting the Request Variable dialog box options (ASP) Setting the Add Parameter dialog box options Setting the Add Parameter dialog box options Setting the Add Parameter dialog box options (PHP) Setting the Request Variable dialog box options (JSP) Setting the Session Variable dialog box options Setting the Application Variable dialog box options Setting the URL Variable dialog box options (ColdFusion) Setting the Form Variable dialog box options (ColdFusion) Setting the Client Variable dialog box options (ColdFusion) Setting the Cookie Variable dialog box options Setting the CGI Variable dialog box options Setting the Server Variable dialog box options Setting the Local Variable dialog box options Setting the JavaBean dialog box options Setting the JavaBean Collection dialog box options Adding Dynamic Content to Web Pages About adding dynamic content Dynamic text Changing dynamic content Making text dynamic Making images dynamic Making HTML attributes dynamic Making ActiveX, Flash, and other object parameters dynamic Editing dynamic content Deleting dynamic content Creating dynamic pages in a Contribute site Reference Setting the Dynamic Text dialog box options Setting the Dynamic Data dialog box options Setting the Property inspector for recordsets Setting the Property inspector for ColdFusion stored procedures, ASP commands, and JSP callables Setting the Property inspector for JSP prepared statements Setting the Property inspector for repeated regions Displaying Database Records About displaying database records Server behaviors and formatting elements Applying typographic and page layout elements to dynamic data Navigating database recordset results Custom recordset navigation bars Navigation bar design tasks Displaying and hiding regions based on recordset results Displaying multiple recordset results Record counters About the ASP.NET DataGrid and DataList controls Using predefined data formats Customizing existing data formats Creating new data formats Creating recordset navigation links Creating a navigation bar using the Recordset Navigation Bar server behavior Creating a custom recordset navigation bar Showing and hiding regions based on recordset results Displaying multiple recordset results Creating a table with a Repeat Region server behavior Creating a record counter Creating a record counter using the Recordset Navigation Status object Creating custom record counters Creating ASP.NET DataGrid and DataList web controls Adding an ASP.NET DataGrid to a page Adding an ASP.NET DataList to your page Modifying a DataGrid or DataList object Reference Setting the Insert Recordset Navigation Bar dialog box options Setting the Move To (server behavior) dialog box options Setting the Repeat Region dialog box options Setting the Insert Recordset Navigation Status dialog box options Setting the Edit Format List dialog box options Setting the Currency, Number, or Percent dialog box options Setting the ASP.NET DataGrid Object dialog box options Setting the Simple Data Field dialog box options Setting the Free Form dialog box options Setting the Simple Data Field dialog box options Setting the Edit, Update, Cancel Buttons dialog box options Setting the Delete Button dialog box options Setting the ASP.NET DataList Object dialog box options Setting the Add Data Field dialog box options Setting the ASP.NET DataGrid Property inspector options Setting the ASP.NET DataList Property inspector options Using ColdFusion Components About ColdFusion components Visually creating a component in Dreamweaver Viewing ColdFusion components in Dreamweaver Editing ColdFusion components in Dreamweaver Building web pages that use ColdFusion components Reference Setting the Create Component dialog box options Setting the CF Components panel options Using Web Services About web services The Dreamweaver web service workflow Finding web service publishers Web service software components Web service references About proxy generators Obtaining additional proxy generators Configuring proxy generators for use with Dreamweaver Adding a web service proxy using the WSDL description Adding a web service to a page Editing the UDDI web service site list Reference Setting the Web Services Chooser dialog box options Setting the Proxy Generators dialog box options Setting the Default Proxy Generator dialog box options Setting the Select Server Model dialog box options Setting the UDDI Site dialog box options ColdFusion Proxy Generator dialog box Setting the Add Using Proxy Classes dialog box Adding Custom Server Behaviors About custom server behaviors Server behaviors About code blocks Parameters in server behaviors Making code blocks conditional Effectively using conditional expressions Repeating code blocks Using the loop directive's _length and _index variables Coding guidelines Testing server behaviors Installing third-party server behaviors Using the Server Behavior Builder Using parameters in server behaviors Positioning code blocks Creating a dialog box for a custom server behavior Editing and modifying server behaviors Reference Setting the New Server Behavior dialog box options Setting the Server Behavior Builder dialog box options Setting the Insert Parameter in Code Block dialog box options Setting the Create a New Code Block dialog box options Setting the Generate Behavior Dialog Box dialog box options Setting the Edit Server Behaviors dialog box options Creating Forms About forms Client-side role of forms Form objects Dynamic form objects Creating HTML forms Inserting HTML form objects Inserting HTML text fields Inserting HTML checkboxes Inserting HTML radio buttons Inserting HTML form menus Inserting standard buttons Inserting image buttons Inserting hidden fields Inserting file-upload fields Inserting dynamic HTML form objects Creating a dynamic HTML form menu Making existing HTML form menus dynamic Displaying dynamic content in HTML text fields Dynamically preselecting HTML checkboxes Dynamically preselecting HTML radio buttons Validating HTML form data Attaching JavaScript behaviors to HTML form objects Attaching custom scripts to HTML form buttons Creating accessible HTML forms Creating ASP.NET forms Adding ASP.NET form controls to a page Setting the properties of ASP.NET form controls Creating a dynamic ASP.NET menu Making an existing ASP.NET menu dynamic Displaying dynamic content in an ASP.NET TextBox control Dynamically preselecting ASP.NET CheckBox controls Dynamically preselecting an item in an ASP.NET RadioButtonList Reference Setting form properties Setting text field properties Setting checkbox properties Setting radio button properties Setting menu properties Setting button properties Setting image field properties Setting hidden field properties Setting file field properties Setting Input Name properties Setting the Input Tag Accessibility Attributes dialog box options Setting the Radio Group dialog box options Setting the Dynamic Radio Group dialog box options (ColdFusion, ASP.NET) Setting the Dynamic Radio Group dialog box options Setting the Dynamic Text Field dialog box options Setting the Dynamic CheckBox dialog box options Setting the Dynamic List/Menu dialog box options Setting the List Values dialog box options Setting the asp:Button dialog box options Setting the asp:CheckBox dialog box options Setting the asp:ImageButton dialog box options Setting the asp:Label dialog box options Setting the asp:RadioButton dialog box options Setting the asp:TextBox dialog box options Setting the asp:CheckBoxList dialog box options Setting the asp:DropDownList dialog box options Setting the asp:ListBox dialog box options Setting the asp:RadioButtonList dialog box options Setting Button properties (ASP.NET) Setting CheckBox properties (ASP.NET) Setting ImageButton properties (ASP.NET) Setting Label properties (ASP.NET) Setting RadioButton properties (ASP.NET) Setting TextBox properties (ASP.NET) Setting CheckBoxList properties (ASP.NET) Setting DropDownList properties (ASP.NET) Setting ListBox properties (ASP.NET) Setting RadioButtonList properties (ASP.NET) Setting the List Items dialog box options Developing Applications Rapidly Building ColdFusion Applications Rapidly About rapid application development (all servers) About master/detail pages About search/results pages About advanced database manipulation objects Stored procedures ASP command objects JSP prepared statements Building master/detail pages (ColdFusion) Building master/detail pages in one operation (ColdFusion, ASP, JSP, PHP) Building master/detail pages block by block (ColdFusion) Creating the master page (ColdFusion) Creating the links to the detail page (ColdFusion) Creating a URL parameter for the links (ColdFusion) Finding and displaying the requested record on the detail page (ColdFusion) Building search/results pages (ColdFusion, ASP, JSP, PHP) Building the search page Building the results page Searching with only one search parameter Searching with multiple search parameters Displaying the results Creating a detail page for a results page Building a record insert page (all servers) Building the insert page in one operation Building an insert page block by block Building pages to update a record (ColdFusion) Searching for the record to update (ColdFusion) Creating the links to open the update page (ColdFusion) Creating a URL parameter for update links (ColdFusion) Retrieving the record to update (ColdFusion) Completing the update page in one operation (ColdFusion) Completing the update page block by block (ColdFusion) Building pages to delete a record (ColdFusion) Searching for the record to delete (ColdFusion) Creating links to a confirmation page (ColdFusion) Creating a URL parameter to pass to the confirmation page (ColdFusion) Displaying the record on the confirmation page (ColdFusion) Adding logic to delete the record (ColdFusion) Using stored procedures to modify databases (ColdFusion) Building pages that restrict access to your site (ColdFusion, ASP, JSP, PHP) Building a registration page Storing login information about users Letting users choose a user name and password Updating the table of users in the database Making sure the chosen user name is unique Building a login page Creating a database table of registered users Letting users log in Checking the user name and password Building a page only authorized users can access Redirecting unauthorized users to another page Storing access privileges in the user database Logging out users Reference Setting the Master Detail Page Set dialog box options Setting the Record Insertion Form dialog box options Setting the Form Element Properties dialog box options Setting the Insert Record dialog box options (ASP & JSP) Setting the Insert Record dialog box options (PHP) Setting the Insert Record dialog box options (ColdFusion) Setting the Insert Record dialog box options (ASP.NET) Setting the Record Update Form dialog box options Setting the Update Record dialog box options (ColdFusion) Setting the Delete Record dialog box options (ColdFusion) Setting the ColdFusion Stored Procedure dialog box options Setting the Stored Procedure Variable dialog box options Setting the Check New Username dialog box options Setting the Log In User dialog box options Setting the Restrict Access To Page dialog box options Setting the Define Access Levels dialog box options Setting the Log Out User dialog box options Related topics Building ASP.NET Applications Rapidly Building master/detail pages (ASP.NET) Creating the master page (ASP.NET) Opening a detail page and passing a record ID (ASP.NET) Finding and displaying the requested record on the detail page (ASP.NET) Building a database search page (ASP.NET) Adding the search controls (ASP.NET) Searching with only one search parameter (ASP.NET) Searching with multiple search parameters (ASP.NET) Displaying the results in a DataGrid Hiding the DataGrid the first time the page loads Creating a detail page (ASP.NET) Building a record insert page (ASP.NET) Building pages to update a record (ASP.NET) Searching for the record to update (ASP.NET) Opening the update page and passing the record ID (ASP.NET) Retrieving the record to update (ASP.NET) Completing the update page in one operation (ASP.NET) Completing the update page block by block (ASP.NET) Building pages to delete a record (ASP.NET) Searching for the record to delete (ASP.NET) Creating delete links on the search page (ASP.NET) Displaying the record on the confirmation page (ASP.NET) Adding logic to delete the record (ASP.NET) Using stored procedures to modify databases (ASP.NET) Building pages that restrict access to your site (ASP.NET) Reference Setting the Record Update Form dialog box options (ASP.NET) Setting the Update Record dialog box options (ASP.NET) Setting the Delete Record dialog box options (ASP.NET) Setting the Stored Procedure dialog box options (ASP.NET) Setting the Edit Stored Procedure Variable dialog box options (ASP.NET) Setting the Build Value dialog box options (ASP.NET) Building ASP and JSP Applications Rapidly Building master/detail pages (ASP and JSP) Building master/detail pages in one operation (ASP and JSP) Building master/detail pages block by block (ASP and JSP) Creating a master page and defining a recordset for it (ASP and JSP) Displaying the records on the master page (ASP and JSP) Opening the detail page and passing a record ID to it (ASP and JSP) Finding and displaying the requested record on the detail page (ASP and JSP) Building search/results pages (ASP and JSP) Building a record insert page (ASP and JSP) Building pages to update a record (ASP and JSP) Searching for the record to update (ASP and JSP) Opening the update page and passing the record ID (ASP and JSP) Retrieving the record to update (ASP and JSP) Completing the update page in one operation (ASP and JSP) Completing the update page block by block (ASP and JSP) Building pages to delete a record (ASP and JSP) Identifying the record to delete (ASP and JSP) Retrieving the record to delete (ASP and JSP) Displaying the data to be deleted (ASP and JSP) Sending the delete command to the server (ASP and JSP) Deleting the record from the database table (ASP and JSP) Building pages with advanced data manipulation objects (ASP and JSP) Using stored procedures to modify databases (ASP and JSP) Running a stored procedure (ASP) Running a stored procedure (JSP) Using ASP commands to modify a database Using JSP prepared statements to modify a database Building pages that restrict access to your site (ASP and JSP) Reference Setting the Go to Detail Page dialog box options (ASP and JSP) Setting the Move To Specific Record dialog box options (ASP and JSP) Setting the Go To Related Page dialog box options (ASP and JSP) Setting the Update Record dialog box options (ASP and JSP) Setting the Delete Record dialog box options (ASP and JSP) Setting the Command (Stored Procedure) dialog box options Setting the Callable (Stored Procedure) dialog box options Setting the Prepared (Insert, Update, Delete) dialog box options (JSP) Building PHP Applications Rapidly Building master/detail pages (PHP) Building master/detail pages in one operation (PHP) Building master/detail pages block by block (PHP) Creating the master page (PHP) Creating the links to the detail page (PHP) Creating a URL parameter for the links (PHP) Finding and displaying the requested record on the detail page (PHP) Building search/results pages (PHP) Building a record insert page (PHP) Building pages to update a record (PHP) Searching for the record to update (PHP) Creating the links to open the update page (PHP) Creating a URL parameter for update links (PHP) Retrieving the record to update (PHP) Completing the update page in one operation (PHP) Completing the update page block by block (PHP) Building pages to delete a record (PHP) Searching for the record to delete (PHP) Creating links to a confirmation page (PHP) Creating a URL parameter to pass to the confirmation page (PHP) Displaying the record on the confirmation page (PHP) Adding logic to delete the record (PHP) Building pages that restrict access to your site (PHP) Reference Setting the Update Record dialog box options (PHP) Setting the Delete Record dialog box options (PHP) Appendixes Beginner's Guide to Databases About databases Database design basics Studying Arrow Aircraft's business rules and policies Studying Arrow Aircraft's feature request What questions will users ask the database? Choosing the tables that belong in the database Choosing the columns in each table Defining relationships between the tables Creating the database Understanding database connections Communicating with the database Using database drivers to communicate with your database Viewing the ODBC drivers installed on a Windows system Invoking database drivers Using a DSN SQL Primer Syntax basics Defining the columns of a recordset Limiting the records in a recordset Sorting the records in a recordset Joining tables Dreamweaver Basics Welcome to Dreamweaver What's new in Dreamweaver MX 2004 Streamlined design and development interface Modernized page layout and design environment Powerful and open coding environment Where to start Web-design novices Experienced web designers Experienced hand-coders Web application developers Dreamweaver workflow for creating websites Planning your site Managing your site files Laying out web pages Adding content to pages Hand-coding Setting up a web application Creating dynamic pages Rapid application development Using Dreamweaver with other applications Dreamweaver and accessibility The Dreamweaver accessibility validation feature Guide to Dreamweaver instructional media Dreamweaver Help systems Macromedia website resources Additional books and training Typographical conventions HTML and web technologies resources Exploring the Workspace About the Dreamweaver workspace The workspace layout Dreamweaver workspace elements The Document window The Document toolbar The Standard toolbar The status bar The Insert bar Reports in Dreamweaver About customizing Dreamweaver in multiuser systems Working in the Document window Switching between views in the Document window Resizing the Document window Setting Status Bar preferences Using toolbars, inspectors, and context menus Displaying toolbars Using the Insert bar Displaying the Insert bar and its categories and menus Using the Insert bar to insert objects Customizing and using the Favorites category in the Insert bar Using the Property inspector Using context menus Using panels and panel groups Viewing panels and panel groups Docking and undocking panels and panel groups Resizing and renaming panel groups Setting Panels preferences Using Dreamweaver accessibility features Using screen readers with Dreamweaver Support for operating system accessibility features (Windows only) Using the keyboard to navigate Dreamweaver Navigating panels Navigating the Property inspector Navigating dialog boxes Navigating frames Navigating tables Optimizing the workspace for accessible page design Using visual guides in Dreamweaver Dreamweaver customizing basics Choosing the workspace layout (Windows only) Hiding and displaying the Start page Setting General preferences for Dreamweaver Setting Fonts preferences for Dreamweaver display Customizing keyboard shortcuts Adding extensions to Dreamweaver Reference Setting Fonts preferences Setting General preferences Setting Highlighting preferences Setting Panels preferences Setting Status Bar preferences Setting the Customize Favorite Objects dialog box options Setting the Rename Panel Group dialog box options Setting the Acronym or Abbreviation dialog box options Setting Accessibility preferences Setting the Keyboard Shortcuts dialog box options Setting Dreamweaver preferences Setting Up a Dreamweaver Site About Dreamweaver sites Understanding local and remote folder structure Setting up a new Dreamweaver site Using the Advanced settings to set up a Dreamweaver site Setting up a local folder Setting up a remote folder Troubleshooting the remote folder setup Editing settings for a Dreamweaver site Editing existing websites in Dreamweaver Editing an existing local website in Dreamweaver Editing an existing remote website in Dreamweaver Reference Setting the Site Definition Wizard Editing Files options Setting the Site Definition Wizard Editing Files options Setting the Site Definition Wizard Editing Files options Setting the Site Definition Wizard Testing Files options Setting local/network access options for testing Setting FTP access options for testing Setting RDS access options for testing Setting the Site Definition Wizard Testing Files options Setting the Site Definition Wizard Sharing Files options Setting the Site Definition Wizard Sharing Files options Setting local/network options for remote access Setting FTP options for remote access Setting the Site Definition Wizard Sharing Files options Site Definition Wizard Summary options Setting Local Info category options Setting Remote Info category options Related topics Setting Remote options for Local/Network access Setting Remote options for FTP access Setting up RDS access Setting up SourceSafe database access Setting up WebDAV access Using the Manage Sites dialog box options Creating and Opening Documents Creating new documents Creating a new blank document Creating a document based on a Dreamweaver design file Creating a document based on an existing template Saving a new document Setting a default new document type Opening existing documents Importing a Microsoft Word HTML file Reference Setting the New Document dialog box options Setting options in the General tab of the New Document dialog box Setting options in the Templates tab of the New Document dialog box Setting options in the New Document Preferences dialog box Setting options for the Clean Up Word HTML dialog box Working with Dreamweaver Sites Managing Your Files About site management The Check In/Check Out system Site cloaking Design Notes Accessing sites, a server, and local drives Setting up Dreamweaver to work without defining a site Viewing files and folders Customizing the file and folder details displayed in the expanded Files panel Managing files and folders in the Files panel Setting preferences for the Files panel Working with files in the Files panel Finding files in your Dreamweaver site Working with a visual map of your site Viewing a site map Modifying the site map layout Working with pages in the site map Showing and hiding site map files Viewing the site from a branch Saving the site map Importing and exporting sites Removing a Dreamweaver site from your list of sites Checking in and checking out files Setting up the Check In/Check Out system Checking files into and out of a remote folder Undoing a file check-out Getting and putting files to and from your server Getting files from a remote server Putting files on a remote server Synchronizing the files on your local and remote sites Cloaking folders and files in your site Enabling and disabling site cloaking Cloaking and uncloaking site folders Cloaking and uncloaking specific file types Uncloaking all folders and files Storing file information in Design Notes Enabling and disabling Design Notes for a site Associating Design Notes with files Working with Design Notes Testing your site Site testing guidelines Using reports to test your site Reference Setting the Configure Server dialog box options Setting the Configure Server dialog box options for FTP Setting the Configure Server dialog box options for RDS Using the Files panel Setting Site preference options Setting File View Columns category options Setting Select Recently Modified dialog box options Setting Site Map Layout category options Setting Check In/Out options Setting Synchronize Files dialog box options Setting the Design Notes category options Setting the Design Notes dialog box options Setting Cloaking category options Setting Reports dialog box options Setting Recently Modified dialog box options Managing Site Assets and Libraries About library items Related topics Working with assets Viewing assets in the Assets panel Refreshing the Assets panel Adding an asset to a document Applying a color to text using the Assets panel Applying a URL to an image or text using the Assets panel Selecting and editing assets Reusing assets in another site Creating and managing a list of favorite assets Adding assets to and removing assets from the Favorites list Creating a nickname for a favorite asset Grouping assets in a Favorites folder Working with library items Creating a library item Inserting a library item in a document Editing a library item Setting library highlighting preferences Editing the properties for a library item Making library items editable in a document Editing a behavior in a library item Reference Using the Assets panel Setting Library item properties Managing Contribute Sites with Dreamweaver About managing Contribute sites Site structure and page design for a Contribute site Site connection for Contribute compatibility File transfer to or from a Contribute site Contribute file and folder permissions on the server Contribute special files Preparing a site for use with Contribute Administering a Contribute site using Dreamweaver Troubleshooting a Contribute site Troubleshooting connection problems for a Contribute site Troubleshooting the Contribute administration tools Managing Contribute files using Dreamweaver Deleting, moving, or renaming a remote file in a Contribute site Enabling Contribute users to access templates without root folder access Unlocking a file in a Contribute site Reference Setting options for the Contribute category in the Manage Sites dialog box Laying Out Pages Laying Out Pages with CSS About layers in Dreamweaver Understanding layers HTML code for layers Inserting content blocks for layout Changing highlight color for content blocks Working with content blocks for layout Inserting a layer Nesting layers Setting layer preferences and properties Setting layer preferences Viewing and setting properties for a single layer Viewing and setting properties for multiple layers Managing layers Using the Layers panel Selecting layers Changing the stacking order of layers Changing layer visibility Manipulating layers Resizing layers Moving layers Aligning layers Converting layers to tables Preventing layer overlaps Converting between layers and tables Using rulers and grids to lay out pages Using a tracing image Reference Setting the Insert Div Tag dialog box options Setting the Layers Preferences dialog box options Setting layer properties Setting properties for multiple layers Setting the Convert Layers to Table dialog box options Setting the Convert Tables to Layers dialog box options Setting the Grid Settings dialog box options Presenting Content with Tables About tables Table formatting precedence in HTML About splitting and merging table cells Inserting a table and adding content Importing and exporting tabular data Selecting table elements Selecting a table Selecting rows or columns Selecting cells Using Expanded Tables mode for easier table editing Formatting tables and cells Viewing and setting table, cell, row, and column properties Editing accessibility attributes for a table Using a design scheme to format a table Resizing tables, columns, and rows Resizing a table Resizing columns and rows Making column widths in code consistent with visual widths Clearing set widths and heights Displaying table and column widths and menus Adding and removing rows and columns Splitting and merging cells Copying, pasting, and deleting cells Nesting tables Sorting tables Reference Setting the Insert Table dialog box options Setting the Import Tabular Data dialog box options Setting table properties Setting cell, row, and column properties Setting the Format Table dialog box options Setting the Insert Rows or Columns dialog box options Setting the Split Cell dialog box options Setting the Sort Table dialog box options Setting the Export Table dialog box options Laying Out Pages in Layout Mode About Layout mode About viewing table and cell widths in Layout mode Layout table and cells grid lines Fixed column width and autostretch columns Spacer images Switching from Standard to Layout mode Drawing in Layout mode Drawing layout cells and tables Drawing a nested layout table Adding content to a layout cell Clearing automatically set cell heights Resizing and moving layout cells and tables Resizing and moving layout cells Resizing and moving layout tables Formatting layout cells and tables Formatting layout cells Formatting layout tables Setting column width Making a column autostretch or fixed-width Using spacer images Making column widths in code consistent with visual widths Setting preferences for Layout mode Reference Setting layout cell properties Setting layout table properties Setting the Choose Spacer Image dialog box options Setting the Layout Mode Preferences dialog box options Using Frames About frames and framesets Understanding how frames and framesets work Deciding whether to use frames Understanding nested framesets Working with framesets in the Document window Creating frames and framesets Using a predefined frameset Designing a frameset Selecting frames and framesets Selecting frames and framesets in the Frames panel Selecting frames and framesets in the Document window Opening a document in a frame Saving frame and frameset files Viewing and setting frame properties and attributes Viewing and setting frameset properties Controlling frame content with links Handling browsers that can't display frames Using JavaScript behaviors with frames Reference Setting frame Property inspector options Setting frameset Property inspector options Setting the Frame Tag Accessibility Attributes dialog box options Managing Templates About Dreamweaver templates Types of template regions Templates and template-based documents in Design and Code views Viewing templates in Design view Viewing templates in Code view Viewing template-based documents in Design view Viewing template-based documents in Code view Template tag syntax General syntax rules Template tags Instance tags Links in templates Nested templates Server scripts in templates and template-based documents Template parameters Template expressions The template expression language The Multiple If condition in template code Creating a Dreamweaver template Customizing code coloring preferences for a template Setting highlighting preferences for template regions Creating templates for a Contribute site Creating editable regions Inserting an editable region Selecting editable regions Removing an editable region Changing an editable region's name Creating repeating regions Creating a repeating region in a template Inserting a repeating table Setting alternating background colors in a repeating table Using optional regions Inserting an optional region Modifying an optional region Defining editable tag attributes Specifying editable tag attributes in a template Making an editable tag attribute uneditable Creating a nested template Editing and updating templates Opening a template for editing Manually updating documents that are based on templates Updating templates in a Contribute site Checking template syntax Managing templates Exporting and importing template XML content Exporting a site without template markup Applying or removing a template from an existing document Applying a template to an existing document Detaching a document from a template Editing content in a template-based document Modifying template properties Adding, deleting, and changing the order of a repeating region entry Reference Setting the Save As Template dialog box options Setting the New Editable Region dialog box options Setting the New Repeating Region dialog box options Setting the Insert Repeating Table dialog box options Setting the Optional Region dialog box options Resolving inconsistent region names Setting options for the Editable Tag Attributes dialog box Using the Assets panel to manage templates Setting options for the Update Pages dialog box Setting the Export Template Data as XML dialog box Setting options for the Export Site Without Template Markup dialog box Adding Content to Pages Working with Pages About working with pages About setting page properties About the History panel About web-safe colors Understanding document encoding About using saved commands versus playing back steps Saving web pages Specifying HTML instead of CSS Setting page properties Changing the document title Setting CSS link underline styles Working with colors Defining default text colors Selecting elements in the Document window Showing and hiding invisible elements Using the History panel Automating tasks Repeating steps Applying steps to another object Applying steps to multiple objects Copying and pasting steps between documents Creating new commands from history steps Recording commands Using JavaScript behaviors to detect browsers and plug-ins Previewing and testing pages in browsers Setting download time and size preferences Reference Setting the Title/Encoding Page Properties options Setting the HTML Appearance Page Properties options Setting the CSS Appearance Page Properties options Setting the CSS Links Page Properties options Setting the CSS Headings Page Properties options Setting Tracing Image Page Properties options Setting Invisible Elements preferences Setting the Preview in Browser Preferences options Inserting and Formatting Text About text formatting in Dreamweaver About inserting text About formatting text About conflicting CSS styles Shorthand CSS properties The Property inspector and text formatting The Relevant CSS tab The CSS Properties tab Inserting text Adding text to a document Importing tabular data documents Copying and pasting text from MS Office documents Formatting paragraphs and document structure Formatting paragraphs Aligning text Indenting text Adding paragraph spacing Using horizontal rules Creating bulleted and numbered lists Formatting text Setting and changing fonts and styles Renaming a style Modifying font combinations Changing the text color Inserting dates Inserting special characters Adding space between characters Using Cascading Style Sheets styles Using the CSS Styles panel Using the Relevant CSS tab Using the CSS Properties tab Creating a new CSS style Applying a Class style Exporting styles to create a CSS style sheet Linking to or importing an external CSS style sheet Using the sample Dreamweaver style sheets Editing a CSS style Editing a CSS style sheet Updating CSS style sheets in a Contribute site Using Design-Time style sheets Checking spelling Searching for and replacing text Reference Setting text property options Setting List Properties dialog box options Setting CSS Styles preferences Renaming a style Defining CSS type properties Defining CSS style background properties Defining CSS style block properties Defining CSS style box properties Defining CSS style border properties Defining CSS style list properties Defining CSS style positioning properties Defining CSS style extension properties Setting the Edit Style Sheet dialog box options Setting spelling options Setting the Find and Replace dialog box options Setting the Find and Replace dialog box options for a specific tag search Setting the Find and Replace dialog box options for an advanced text search Setting the Search panel options Inserting Images About images Editing images in Dreamweaver Inserting an image Inserting an image placeholder Aligning an image Resizing an image Cropping an image Optimizing an image using Fireworks Adjusting the brightness and contrast of an image Sharpening an image Creating a rollover image Using an external image editor Applying behaviors to images Reference Setting image properties Setting the Image Tag Accessibility Attributes dialog box options Completing the Image Placeholder dialog box Setting image placeholder properties Setting external image editor preferences Setting the Image Rollover dialog box options Setting the Brightness and Contrast dialog box options Setting the Sharpen Image dialog box options Linking and Navigation Understanding document locations and paths Absolute paths Document-relative paths Jump menus Navigation bars About image maps Creating links Linking files and documents Linking to documents using the Property inspector Linking documents using the Point-to-File icon Linking documents using the site map Using the Hyperlink command Linking to a specific place in a document Managing links Changing a link sitewide Inserting jump menus Using navigation bars Using image maps Attaching JavaScript behaviors to links Checking for broken, external, and orphaned links Fixing broken links Opening linked documents in Dreamweaver Reference Setting the Named Anchor option Setting hyperlink options Setting E-mail Link options Setting the Change Link Sitewide options Setting Insert Jump Menu options Setting Navigation Bar options Setting the Hotspot Property inspector options Working with Other Applications About Fireworks and Flash integration Optimizing your work environment for Fireworks and Flash Working with Fireworks Inserting a Fireworks image Editing a Fireworks image or table from Dreamweaver Optimizing a Fireworks image from Dreamweaver Using Fireworks to modify Dreamweaver image placeholders Specifying launch-and-edit preferences for Fireworks source files Working with Flash Editing Flash content in Dreamweaver Adding Audio, Video, and Interactive Elements About media files Flash file types Audio file formats Inserting and editing media objects Editing accessibility attributes for media objects Starting an external editor for media files Specifying the editor to start from Dreamweaver Using Design Notes with media objects Inserting and modifying a Flash button object Creating and inserting a Flash button Modifying a Flash button object Playing a Flash button object in the document Inserting a Flash text object Inserting Flash content Downloading and installing Flash elements Inserting Flash elements Editing Flash element attributes Inserting Shockwave movies Adding video Adding sound to a page Embedding a sound file Inserting Netscape Navigator plug-in content Inserting plug-in content in your page Playing plug-ins in the Document window Troubleshooting Netscape Navigator plug-ins Inserting an ActiveX control Inserting a Java applet Using behaviors to control media Reference Setting Flash object properties Using parameters to control media objects Setting Flash and Shockwave movie properties Setting Netscape Navigator plug-in properties Setting ActiveX properties Setting Java applet properties Setting the Object Tag Accessibility Attributes dialog box options Setting the Insert Flash Button dialog box options Setting the Flash element inspector Setting the Flash element Edit Array dialog box options Using JavaScript Behaviors Using the Behaviors panel About events Applying a behavior Attaching a behavior to text Changing a behavior Updating a behavior Creating new actions Downloading and installing third-party behaviors Using the behavior actions that come with Dreamweaver Call JavaScript Change Property Check Browser Check Plugin Control Shockwave or Flash Drag Layer Gathering information about the draggable layer Go to URL Jump Menu Jump Menu Go Open Browser Window Play Sound Popup Message Preload Images Set Nav Bar Image Set Text of Frame Set Text of Layer Set Text of Status Bar Set Text of Text Field Show-Hide Layers Show Pop-Up Menu Adding, removing, and changing the order of pop-up menu items Setting the appearance of a pop-up menu Setting advanced appearance options Setting a pop-up menu's position in a document Modifying a pop-up menu Swap Image Swap Image Restore Validate Form Reference Setting the Behaviors panel options Working with Page Code Setting Up Your Coding Environment Viewing your code Using the coder-oriented workspace (Windows only) Setting viewing preferences Setting coding preferences Setting code formatting preferences Applying new formatting preferences to existing documents Setting code hints preferences Setting code rewriting preferences Setting code coloring preferences Customizing keyboard shortcuts Opening files in Code view by default Setting Validator preferences Managing tag libraries Opening and closing the Tag Library editor Adding libraries, tags, and attributes Editing libraries, tags, and attributes Deleting libraries, tags, and attributes Importing custom tags into Dreamweaver Importing tags from XML files Importing custom ASP.NET tags Importing JSP tags from a file Importing JSP tags from a server (web.xml) Importing JRun tags Using an external HTML editor with Dreamweaver Using an integrated HTML editor Using HomeSite (Windows only) Using BBEdit (Macintosh only) Setting file type and external editor preferences Reference Setting the Tag Library editor dialog box options Setting code-viewing options Setting the code format preference options Setting the code hints preference options Setting the code rewriting preference options Setting the code coloring preference options Setting the Validator preference options Setting the New Tags dialog box options Setting the New Attributes dialog box options Setting the JSP tag library Import from File dialog box options Setting the JSP tag library Import from Server dialog box options Setting the Import JRun Server Tags from Folder dialog box options Setting the File Types/Editors preference options Coding in Dreamweaver About coding in Dreamweaver Supported languages Fixing invalid markup Automatic code modification in Dreamweaver About the XHTML code generated by Dreamweaver Server-side includes Regular expressions About server behavior code Writing and editing code Using code hints Working with code snippets Inserting code quickly with the Insert bar Inserting tags with the Tag Chooser Editing tags with Tag editors Indenting code blocks Copying and pasting code Inserting HTML comments Searching and replacing tags and attributes Searching for tags, attributes, or text contained in specific tags Saving search patterns Making quick changes to a code selection Using language-reference material Printing your code Reference Setting the Snippets panel options Setting the Comment dialog box options Setting the Comment Property inspector options Setting the Tag Chooser dialog box options Optimizing and Debugging Your Code Cleaning up your code Verifying that tags and braces are balanced Checking for browser compatibility Validating your tags Making pages XHTML-compliant Using the ColdFusion debugger (Windows only) Reference Setting the Clean Up HTML dialog box options Editing Code in Design View Editing code with the Property inspector Changing attributes with the Tag inspector Editing code with the Quick Tag Editor Inserting an HTML tag with the Quick Tag Editor Editing an HTML tag with the Quick Tag Editor Applying HTML to a selection with the Quick Tag Editor Using the hints menu Editing code with the tag selector Editing scripts Writing a client-side script in Design view Linking to an external script file Editing a script in Design view Working with server-side includes Inserting a server-side include Editing the contents of a server-side include Using JavaScript behaviors Viewing and editing head content Reference Setting the Quick Tag Editor options Setting Quick Tag Editor preferences Setting the Script dialog box options Setting the Script Properties dialog box options Setting the script Property inspector options Setting the server-side include Property inspector options Setting the ColdFusion tag Property inspector options Setting the ASP script Property inspector options Setting Meta properties Setting Title properties Setting Keywords properties Setting Description properties Setting Refresh properties Setting Base properties Setting properties for the link tag Setting code properties Preparing to Build Dynamic Sites Setting Up a Web Application What you need to build web applications Setting up a web server Setting up an application server Choosing your application server Installing a ColdFusion application server Installing an ASP.NET application server Installing an ASP application server Installing a JSP application server Installing a PHP application server Creating a root folder for the application Defining a Dreamweaver site Defining a local folder Defining a remote folder Specifying where dynamic pages can be processed Connecting to a database Reference Setting the Testing Server category options Setting the URL prefix Database Connections for ColdFusion Developers Connecting to a database Creating a ColdFusion data source Connecting to the database in Dreamweaver Editing or deleting a database connection Database Connections for ASP.NET Developers Connecting to a database Obtaining an OLE DB provider for your database Creating an ASP.NET database connection in Dreamweaver Creating a connection using Data Link Properties Sample OLE DB connection parameters for ASP.NET Editing or deleting a database connection Reference Setting the OLE DB Connection dialog box options Setting the Connection String Template dialog box options Setting the SQL Server Connection dialog box options Database Connections for ASP Developers About database connections in ASP ASP database connections OLE DB connections Creating a DSN connection Creating a connection using a local DSN Creating a DSN-less connection Connecting to a database on an ISP Understanding physical and virtual paths Finding a file's physical path with the virtual path Using a virtual path to connect to a database Editing or deleting a database connection Reference Setting the Data Source Name (DSN) dialog box options Setting the Select ODBC DSN dialog box options Setting the Custom Connection String dialog box options Setting the Connection String option Setting the Connections dialog box options Database Connections for JSP Developers About database connections in JSP JSP connections JDBC connection parameters Connecting to a database Connecting through an ODBC driver Editing or deleting a database connection Reference Database Connections for PHP Developers Connecting to a database Editing or deleting a database connection Reference Setting the MySQL Connection dialog box options Setting the Select Database dialog box options Troubleshooting Database Connections Troubleshooting permissions problems Troubleshooting Microsoft error messages 80004005--Data source name not found and no default driver specified 80004005--Couldn't use '(unknown)'; file already in use 80004005--Logon Failed() 80004005--Operation must use an updateable query 80040e07--Data type mismatch in criteria expression 80040e10--Too few parameters 80040e10--COUNT field incorrect 80040e14--Syntax error in INSERT INTO statement 80040e21--ODBC error on Insert or Update 800a0bcd--Either BOF or EOF is true Making Pages Dynamic Optimizing the Workspace for Visual Development Displaying web-application development panels Viewing your database within Dreamweaver Viewing live data in Design view Requirements for displaying live data Copying dependent files Refreshing the page Working in Design view without live data Previewing dynamic pages in a browser Restricting database information displayed in Dreamweaver Reference Setting the Bindings panel options Setting the Server Behaviors panel options Setting the Databases panel options Setting the Components panel options Setting the Live Data Settings dialog box options Setting the Restrict dialog box options The Workflow for Dynamic Page Design Designing the page Creating a source of dynamic content Adding dynamic content to a web page Enhancing the functionality of a dynamic page Adding server behaviors to a page Testing and debugging the page Testing dynamic content Editing dynamic content on a page Deleting dynamic content Obtaining Data for Your Page Using a database to store content Accessing data stored in a database Collecting data submitted by users Form parameters URL parameters Creating URL parameters using HTML links Retrieving form and URL parameters Accessing data stored in session variables Understanding session variables Collecting information to store in session variables Storing URL parameters in session variables Storing form parameters in session variables Storing information in session variables Example of information stored in session variables Retrieving data from session variables Defining Sources of Dynamic Content About dynamic content sources Understanding recordsets Understanding URL and form parameters About session variables ASP and ColdFusion application variables ASP server variables ColdFusion server variables JavaBeans and JSP Defining a recordset Creating a recordset without writing SQL Creating an advanced recordset by writing SQL Creating SQL queries using the Database Items tree Selecting a table Selecting specific rows from a table and ordering the results Defining URL parameters Defining form parameters Defining session variables Defining application variables for ASP and ColdFusion Using a variable as a data source for a ColdFusion recordset Defining server variables Defining ASP server variables Defining ColdFusion server variables Defining PHP server variables Defining JSP server variables Defining JavaBeans (JSP only) Caching content sources Changing or deleting content sources Copying a recordset from one page to another page Reference Setting the Bindings panel options Setting the simple Recordset dialog box options Setting the simple Recordset dialog box options (ColdFusion) Setting the simple DataSet dialog box options (ASP.NET) Setting the advanced Recordset dialog box Setting the advanced Recordset dialog box (ASP.NET) Setting the advanced Recordset dialog box options (ColdFusion) Setting the Request Variable dialog box options (ASP) Setting the Add Parameter dialog box options Setting the Add Parameter dialog box options Setting the Add Parameter dialog box options (PHP) Setting the Request Variable dialog box options (JSP) Setting the Session Variable dialog box options Setting the Application Variable dialog box options Setting the URL Variable dialog box options (ColdFusion) Setting the Form Variable dialog box options (ColdFusion) Setting the Client Variable dialog box options (ColdFusion) Setting the Cookie Variable dialog box options Setting the CGI Variable dialog box options Setting the Server Variable dialog box options Setting the Local Variable dialog box options Setting the JavaBean dialog box options Setting the JavaBean Collection dialog box options Adding Dynamic Content to Web Pages About adding dynamic content Dynamic text Changing dynamic content Making text dynamic Making images dynamic Making HTML attributes dynamic Making ActiveX, Flash, and other object parameters dynamic Editing dynamic content Deleting dynamic content Creating dynamic pages in a Contribute site Reference Setting the Dynamic Text dialog box options Setting the Dynamic Data dialog box options Setting the Property inspector for recordsets Setting the Property inspector for ColdFusion stored procedures, ASP commands, and JSP callables Setting the Property inspector for JSP prepared statements Setting the Property inspector for repeated regions Displaying Database Records About displaying database records Server behaviors and formatting elements Applying typographic and page layout elements to dynamic data Navigating database recordset results Custom recordset navigation bars Navigation bar design tasks Displaying and hiding regions based on recordset results Displaying multiple recordset results Record counters About the ASP.NET DataGrid and DataList controls Using predefined data formats Customizing existing data formats Creating new data formats Creating recordset navigation links Creating a navigation bar using the Recordset Navigation Bar server behavior Creating a custom recordset navigation bar Showing and hiding regions based on recordset results Displaying multiple recordset results Creating a table with a Repeat Region server behavior Creating a record counter Creating a record counter using the Recordset Navigation Status object Creating custom record counters Creating ASP.NET DataGrid and DataList web controls Adding an ASP.NET DataGrid to a page Adding an ASP.NET DataList to your page Modifying a DataGrid or DataList object Reference Setting the Insert Recordset Navigation Bar dialog box options Setting the Move To (server behavior) dialog box options Setting the Repeat Region dialog box options Setting the Insert Recordset Navigation Status dialog box options Setting the Edit Format List dialog box options Setting the Currency, Number, or Percent dialog box options Setting the ASP.NET DataGrid Object dialog box options Setting the Simple Data Field dialog box options Setting the Free Form dialog box options Setting the Simple Data Field dialog box options Setting the Edit, Update, Cancel Buttons dialog box options Setting the Delete Button dialog box options Setting the ASP.NET DataList Object dialog box options Setting the Add Data Field dialog box options Setting the ASP.NET DataGrid Property inspector options Setting the ASP.NET DataList Property inspector options Using ColdFusion Components About ColdFusion components Visually creating a component in Dreamweaver Viewing ColdFusion components in Dreamweaver Editing ColdFusion components in Dreamweaver Building web pages that use ColdFusion components Reference Setting the Create Component dialog box options Setting the CF Components panel options Using Web Services About web services The Dreamweaver web service workflow Finding web service publishers Web service software components Web service references About proxy generators Obtaining additional proxy generators Configuring proxy generators for use with Dreamweaver Adding a web service proxy using the WSDL description Adding a web service to a page Editing the UDDI web service site list Reference Setting the Web Services Chooser dialog box options Setting the Proxy Generators dialog box options Setting the Default Proxy Generator dialog box options Setting the Select Server Model dialog box options Setting the UDDI Site dialog box options ColdFusion Proxy Generator dialog box Setting the Add Using Proxy Classes dialog box Adding Custom Server Behaviors About custom server behaviors Server behaviors About code blocks Parameters in server behaviors Making code blocks conditional Effectively using conditional expressions Repeating code blocks Using the loop directive's _length and _index variables Coding guidelines Testing server behaviors Installing third-party server behaviors Using the Server Behavior Builder Using parameters in server behaviors Positioning code blocks Creating a dialog box for a custom server behavior Editing and modifying server behaviors Reference Setting the New Server Behavior dialog box options Setting the Server Behavior Builder dialog box options Setting the Insert Parameter in Code Block dialog box options Setting the Create a New Code Block dialog box options Setting the Generate Behavior Dialog Box dialog box options Setting the Edit Server Behaviors dialog box options Creating Forms About forms Client-side role of forms Form objects Dynamic form objects Creating HTML forms Inserting HTML form objects Inserting HTML text fields Inserting HTML checkboxes Inserting HTML radio buttons Inserting HTML form menus Inserting standard buttons Inserting image buttons Inserting hidden fields Inserting file-upload fields Inserting dynamic HTML form objects Creating a dynamic HTML form menu Making existing HTML form menus dynamic Displaying dynamic content in HTML text fields Dynamically preselecting HTML checkboxes Dynamically preselecting HTML radio buttons Validating HTML form data Attaching JavaScript behaviors to HTML form objects Attaching custom scripts to HTML form buttons Creating accessible HTML forms Creating ASP.NET forms Adding ASP.NET form controls to a page Setting the properties of ASP.NET form controls Creating a dynamic ASP.NET menu Making an existing ASP.NET menu dynamic Displaying dynamic content in an ASP.NET TextBox control Dynamically preselecting ASP.NET CheckBox controls Dynamically preselecting an item in an ASP.NET RadioButtonList Reference Setting form properties Setting text field properties Setting checkbox properties Setting radio button properties Setting menu properties Setting button properties Setting image field properties Setting hidden field properties Setting file field properties Setting Input Name properties Setting the Input Tag Accessibility Attributes dialog box options Setting the Radio Group dialog box options Setting the Dynamic Radio Group dialog box options (ColdFusion, ASP.NET) Setting the Dynamic Radio Group dialog box options Setting the Dynamic Text Field dialog box options Setting the Dynamic CheckBox dialog box options Setting the Dynamic List/Menu dialog box options Setting the List Values dialog box options Setting the asp:Button dialog box options Setting the asp:CheckBox dialog box options Setting the asp:ImageButton dialog box options Setting the asp:Label dialog box options Setting the asp:RadioButton dialog box options Setting the asp:TextBox dialog box options Setting the asp:CheckBoxList dialog box options Setting the asp:DropDownList dialog box options Setting the asp:ListBox dialog box options Setting the asp:RadioButtonList dialog box options Setting Button properties (ASP.NET) Setting CheckBox properties (ASP.NET) Setting ImageButton properties (ASP.NET) Setting Label properties (ASP.NET) Setting RadioButton properties (ASP.NET) Setting TextBox properties (ASP.NET) Setting CheckBoxList properties (ASP.NET) Setting DropDownList properties (ASP.NET) Setting ListBox properties (ASP.NET) Setting RadioButtonList properties (ASP.NET) Setting the List Items dialog box options Developing Applications Rapidly Building ColdFusion Applications Rapidly About rapid application development (all servers) About master/detail pages About search/results pages About advanced database manipulation objects Stored procedures ASP command objects JSP prepared statements Building master/detail pages (ColdFusion) Building master/detail pages in one operation (ColdFusion, ASP, JSP, PHP) Building master/detail pages block by block (ColdFusion) Creating the master page (ColdFusion) Creating the links to the detail page (ColdFusion) Creating a URL parameter for the links (ColdFusion) Finding and displaying the requested record on the detail page (ColdFusion) Building search/results pages (ColdFusion, ASP, JSP, PHP) Building the search page Building the results page Searching with only one search parameter Searching with multiple search parameters Displaying the results Creating a detail page for a results page Building a record insert page (all servers) Building the insert page in one operation Building an insert page block by block Building pages to update a record (ColdFusion) Searching for the record to update (ColdFusion) Creating the links to open the update page (ColdFusion) Creating a URL parameter for update links (ColdFusion) Retrieving the record to update (ColdFusion) Completing the update page in one operation (ColdFusion) Completing the update page block by block (ColdFusion) Building pages to delete a record (ColdFusion) Searching for the record to delete (ColdFusion) Creating links to a confirmation page (ColdFusion) Creating a URL parameter to pass to the confirmation page (ColdFusion) Displaying the record on the confirmation page (ColdFusion) Adding logic to delete the record (ColdFusion) Using stored procedures to modify databases (ColdFusion) Building pages that restrict access to your site (ColdFusion, ASP, JSP, PHP) Building a registration page Storing login information about users Letting users choose a user name and password Updating the table of users in the database Making sure the chosen user name is unique Building a login page Creating a database table of registered users Letting users log in Checking the user name and password Building a page only authorized users can access Redirecting unauthorized users to another page Storing access privileges in the user database Logging out users Reference Setting the Master Detail Page Set dialog box options Setting the Record Insertion Form dialog box options Setting the Form Element Properties dialog box options Setting the Insert Record dialog box options (ASP & JSP) Setting the Insert Record dialog box options (PHP) Setting the Insert Record dialog box options (ColdFusion) Setting the Insert Record dialog box options (ASP.NET) Setting the Record Update Form dialog box options Setting the Update Record dialog box options (ColdFusion) Setting the Delete Record dialog box options (ColdFusion) Setting the ColdFusion Stored Procedure dialog box options Setting the Stored Procedure Variable dialog box options Setting the Check New Username dialog box options Setting the Log In User dialog box options Setting the Restrict Access To Page dialog box options Setting the Define Access Levels dialog box options Setting the Log Out User dialog box options Related topics Building ASP.NET Applications Rapidly Building master/detail pages (ASP.NET) Creating the master page (ASP.NET) Opening a detail page and passing a record ID (ASP.NET) Finding and displaying the requested record on the detail page (ASP.NET) Building a database search page (ASP.NET) Adding the search controls (ASP.NET) Searching with only one search parameter (ASP.NET) Searching with multiple search parameters (ASP.NET) Displaying the results in a DataGrid Hiding the DataGrid the first time the page loads Creating a detail page (ASP.NET) Building a record insert page (ASP.NET) Building pages to update a record (ASP.NET) Searching for the record to update (ASP.NET) Opening the update page and passing the record ID (ASP.NET) Retrieving the record to update (ASP.NET) Completing the update page in one operation (ASP.NET) Completing the update page block by block (ASP.NET) Building pages to delete a record (ASP.NET) Searching for the record to delete (ASP.NET) Creating delete links on the search page (ASP.NET) Displaying the record on the confirmation page (ASP.NET) Adding logic to delete the record (ASP.NET) Using stored procedures to modify databases (ASP.NET) Building pages that restrict access to your site (ASP.NET) Reference Setting the Record Update Form dialog box options (ASP.NET) Setting the Update Record dialog box options (ASP.NET) Setting the Delete Record dialog box options (ASP.NET) Setting the Stored Procedure dialog box options (ASP.NET) Setting the Edit Stored Procedure Variable dialog box options (ASP.NET) Setting the Build Value dialog box options (ASP.NET) Building ASP and JSP Applications Rapidly Building master/detail pages (ASP and JSP) Building master/detail pages in one operation (ASP and JSP) Building master/detail pages block by block (ASP and JSP) Creating a master page and defining a recordset for it (ASP and JSP) Displaying the records on the master page (ASP and JSP) Opening the detail page and passing a record ID to it (ASP and JSP) Finding and displaying the requested record on the detail page (ASP and JSP) Building search/results pages (ASP and JSP) Building a record insert page (ASP and JSP) Building pages to update a record (ASP and JSP) Searching for the record to update (ASP and JSP) Opening the update page and passing the record ID (ASP and JSP) Retrieving the record to update (ASP and JSP) Completing the update page in one operation (ASP and JSP) Completing the update page block by block (ASP and JSP) Building pages to delete a record (ASP and JSP) Identifying the record to delete (ASP and JSP) Retrieving the record to delete (ASP and JSP) Displaying the data to be deleted (ASP and JSP) Sending the delete command to the server (ASP and JSP) Deleting the record from the database table (ASP and JSP) Building pages with advanced data manipulation objects (ASP and JSP) Using stored procedures to modify databases (ASP and JSP) Running a stored procedure (ASP) Running a stored procedure (JSP) Using ASP commands to modify a database Using JSP prepared statements to modify a database Building pages that restrict access to your site (ASP and JSP) Reference Setting the Go to Detail Page dialog box options (ASP and JSP) Setting the Move To Specific Record dialog box options (ASP and JSP) Setting the Go To Related Page dialog box options (ASP and JSP) Setting the Update Record dialog box options (ASP and JSP) Setting the Delete Record dialog box options (ASP and JSP) Setting the Command (Stored Procedure) dialog box options Setting the Callable (Stored Procedure) dialog box options Setting the Prepared (Insert, Update, Delete) dialog box options (JSP) Building PHP Applications Rapidly Building master/detail pages (PHP) Building master/detail pages in one operation (PHP) Building master/detail pages block by block (PHP) Creating the master page (PHP) Creating the links to the detail page (PHP) Creating a URL parameter for the links (PHP) Finding and displaying the requested record on the detail page (PHP) Building search/results pages (PHP) Building a record insert page (PHP) Building pages to update a record (PHP) Searching for the record to update (PHP) Creating the links to open the update page (PHP) Creating a URL parameter for update links (PHP) Retrieving the record to update (PHP) Completing the update page in one operation (PHP) Completing the update page block by block (PHP) Building pages to delete a record (PHP) Searching for the record to delete (PHP) Creating links to a confirmation page (PHP) Creating a URL parameter to pass to the confirmation page (PHP) Displaying the record on the confirmation page (PHP) Adding logic to delete the record (PHP) Building pages that restrict access to your site (PHP) Reference Setting the Update Record dialog box options (PHP) Setting the Delete Record dialog box options (PHP) Appendixes Beginner's Guide to Databases About databases Database design basics Studying Arrow Aircraft's business rules and policies Studying Arrow Aircraft's feature request What questions will users ask the database? Choosing the tables that belong in the database Choosing the columns in each table Defining relationships between the tables Creating the database Understanding database connections Communicating with the database Using database drivers to communicate with your database Viewing the ODBC drivers installed on a Windows system Invoking database drivers Using a DSN SQL Primer Syntax basics Defining the columns of a recordset Limiting the records in a recordset Sorting the records in a recordset Joining tables