dreamweaver cs5 all-in-one for dummies : [9 books in 1 ... · dreamweaver®css all-in-one for...

17
Dreamweaver® CSS ALL-IN-ONE FOR DUMHIE&' by Sue Jenkins and Richard Wagner WILEY Wiley Publishing, Inc.

Upload: others

Post on 13-May-2020

5 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Dreamweaver® CSSALL-IN-ONE

FOR

DUMHIE&'

by Sue Jenkins and Richard Wagner

WILEY

Wiley Publishing, Inc.

Page 2: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Table of Contentsft#«e?Sft»l*l^ifPi»*#i4«4l«t###*5!®i#*l®*®^*9#l#»«#Sll

Introduction.«

/

About This Book 2

Conventions Used in This Book 2

What You Don't Have to Read 3

Assumptions About You 3

How This Book Is Organized 3

Book I: Getting Started 3

Book II: Mastering the Basics 3

Book III: Working Like the Pros 4

Book IV: Energizing Your Site 4

Book V: Publishing Your Site 4

Book VI: Working Collaboratively 4

Book VII: Building Web Applications 4

Book VIII: Making Pages Dynamic 5

Book IX: Developing Applications Rapidly 5

Icons Used in This Book 5

Where to Go from Here 6

Book h Getting Started 9

Chapter 1: Cruising Around the Dreamweaver CS5 Workspace 11

Choosing a Workspace Layout 11

Getting to Know the Dreamweaver Workspace 13

Exploring the Document Window 17

Document tab bar 17

Document and Browser Navigation toolbars 18

Rulers 22

Grids 22

Guides 23

Status bar 23

Understanding the Panels and the Properties Inspector 24

Understanding the panel dock 24

Accessing panels and panel groups 25

Using the Insert panel 26

Using the Properties inspector 27

Working with the Files panel 27

Customizing the Workspace 29

Setting Dreamweaver Preferences 30

Page 3: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Ml breamtfeatfer CSS Att-in-One For dummies

Finding Help 30

Using Dreamweaver Help (Fl) 31

Working with the Reference panel 31

Visiting Adobe's Dreamweaver support portal 32

Chapter 2: Planning and Designing Your Site 35

Understanding the Web Design Workflow 35

Knowing Your Audience 36

Denning the client's expectations 36

Exploring the audience's expectations 37

Examining Issues that Affect the Site Design 38

Balancing time, cost, and scope 38

Conveying your message 38

Web site design concepts 38

Considering resolution, optimization, and content 41

Planning the Site Layout 43

Designing and Optimizing Graphics 45

Chapter 3: Creating and Managing Sites 47

Understanding General Web Site Structure 47

Web site construction folders 47

Root-level organization 48

Setting Up a Managed Site 50

Servers 52

Version Control 53

Advanced Settings 53

Managing Multiple Sites 55

Duplicating sites 56

Exporting and importing sites 56

Removing sites from the Manage Sites list 57

Book 11: Mastering the Basics 59

Chapter 1: Creating Documents 61

Creating a New Document 61

Saving Documents 65

Saving a copy of a file 66

Saving multiple documents at once 67

Reverting to a previous version of a file 67

Opening Existing Files 67

Setting Page Properties 68

Understanding Invisible Page Elements 69

Importing Tabular Data Files 72

Importing Word and Excel Files (Windows Only) 73

Page 4: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

« * 4

Table of Contents Kill

Chapter 2: Working with Text 75

Adding Text 75

Editing Text 76

Removing Text 77

Pasting Text from Another File 77

Setting Text Properties in the Properties Inspector 78

HTML Properties Inspector 80

CSS Properties Inspector 82

Creating Inline Styles 85

Inserting Special Characters 86

Creating Lists 87

Editing with the Find and Replace Tool 89

Searching for tags and attributes 89

Searching for text in specific tags 91

Saving and reusing searches 93

Using regular expressions in your searches 94

Chapter 3: Inserting Graphics 95

Inserting Images in Your Web Page 96

Using the Insert panel 96

Using the Insert menu 98

Using the Assets panel 98

Using the Files panel 99

Editing, Deleting, and Moving Inserted Images 99

Using an Image Placeholder When a Graphic Isn't Ready 99

Setting Image Attributes with the Properties Inspector 101

Naming your images 101

Specifying the width and height of images 102

Resizing and resetting images 102

Adding vertical or horizontal padding 103

Adding image links 103

Adjusting targets 103

Specifying the original file 103

Adding image borders 104

Providing Alternate text 104

Aligning images 105

Using the image editing icons 106

Creating Interactive Images 107

Adding rollover images 107

Creating image maps 109

Inserting Fireworks HTML Ill

Chapter 4: Making Links with Text and Images 113

Understanding Hyperlinks 114

Creating Text Links 115

Making Image Links 117

Inserting E-Mail Links 118

Page 5: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

jWV Oreamu/eai/er CS5 Att-in-One For dummies

Creating Named Anchor Links 119

Step 1: Place the named anchor 120

Step 2: Link to the named anchor 121

Creating Temporary Links 122

Setting Link Targets 123

Editing and Deleting Links 123

Editing links 123

Deleting links 124

Using the Tag Chooser 124

Coding Links by Hand 126

Chapter 5: Adding Flash, Movies, Sound, and More 127

Flash Elements You Can Add to Your Web Site 127

Inserting Flash Movies (SWFs) 128

Adding a Flash movie to your page 128

Setting Flash movie attributes 131

Inserting Flash Video 132

Adding Shockwave Movies, Java Applets, and ActiveX Controls 137

Setting Shockwave movie properties 139

Setting Java applet properties 139

Setting ActiveX control properties 140

Adding Netscape Navigator Plug-ins 143

Setting Netscape Navigator plug-in properties 143

Playing Netscape Navigator plug-ins 144

Acceptable Sound File Formats 145

Adding Other Video and Sound to a Page 146

Linking versus embedding video 146

Linking versus embedding sound 147

Launching a Media External Editor 148

Chapter 6: Organizing Data with Tables 151

Creating Tables 152

Inserting a basic table in your page 153

Turning On Table Visual Aids 155

Formatting Tables with the Properties Inspector 156

Merging and Splitting Rows and Columns 158

Merging cells 160

Splitting a cell 160

Setting Table Width and Heights 161

Adding Rows and Columns to a Table 161

Adding a row 161

Adding a column 162

Adding multiple rows or columns 162

Deleting rows and columns 163

Inserting Text and Images in Table Cells 163

Formatting Individual Table Cells ; 163

Changing Table Measurements from Pixels to Percentages 164

Importing Tabular Data 165

Page 6: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Table of Contents XV

Sorting Information in a Table 166

Working with Tables Created by Other Programs 168

Chapter 7: Building Fabulous Forms 169

Organizing Data in Your Form 170

Creating a Fabulous HTML Form 171

Adding and Labeling Form Fields 174

Text fields 174

Hidden fields 177

Check boxes 179

Radio buttons 181

Lists and menus 184

Jump menus186

Image fields 186

File upload fields 187

Buttons 188

Label tags 190

Fieldset tags191

Validating a Form with JavaScript 194

Validating a Form with Spry Assets 195

Book Uh Working Like the Pros 199

Chapter 1: Looking Good with Cascading Style Sheets (CSS) 201

Understanding Cascading Style Sheets (CSS) 202

Exploring Different Style Sheet Types 204

Internal styles 204

External styles 206

Inline styles 207

Working with the CSS Styles Panel 208

All mode 209

Current mode 209

CSS Styles panel viewing icons 210

Understanding CSS Style Types 211

Class styles 212

ID styles (ID) 213

Tag redefine styles 215

Compound styles 215

Adding a Style to a New or Existing Style Sheet 217

Attaching a Style Sheet to Your Document 220

Applying a Class Style 221

Editing a CSS Style 222

Editing in All mode 222

Editing in Current mode 224

Adding properties to a CSS style 224

Deleting a CSS Style 225

Enabling/Disabling CSS Properties 225

Page 7: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

breamuteai/er CS5 Alt-in-One For Dummies

Exploring the CSS Rule Definition Dialog Box 228

Type properties 228

Background properties 230

Block properties 232

Box properties 234

Border properties 235

List properties 236

Positioning properties 237

Extensions properties 239

Renaming CSS Styles 240

Exporting Internal Styles to an External Style Sheet 242

Converting Inline Styles to CSS Rules 243

Using Design Time Style Sheets 245

Using the Code Navigator 246

Identifying Elements with CSS Inspect 247

Chapter 2: Building Sites with Templates 249

Introducing Templates 249

Creating a Template 250

Converting an HTML page into a template 251

Creating a new template from scratch 253

Working with Editable Regions 255

Creating editable regions 256

Removing editable regions 258

Renaming editable regions 259

Exporting a site without any template markup 260

Creating Optional and Optional Editable Regions 261

Creating optional regions 262

Creating optional editable regions 263

Modifying optional regions 264

Creating Repeating Regions and Tables 264

Creating repeating regions 265

Creating repeating tables 266

Creating Editable Tag Attributes 268

Changing editable tag attributes in template-based files 270

Resetting an editable tag attribute to uneditable 270

Building Nested Templates 271

Creating nested templates 271

Modifying nested templates 272

Creating a New Document from a Template 273

Editing Templates and Updating Pages 275

Modifying a template and updating all the pages that use it 275

Selectively updating pages with the most recent version

of the template 276

Applying Templates to Pages 277

Detaching Templates from Pages 278

Managing Templates 279

Renaming a template 279

Deleting a template file 280

Page 8: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Table of Contents KtfH

Chapter 3: Using Library Items and Server-Side Includes 281

Introducing Library Items 282

Creating Library Items 282

Creating a selection-based library item 283

Creating an empty library item 284

Inserting a Library Item in Your Document 285

Editing and Managing Library Items 287

Editing library items 287

Updating documents and sites that use library items 288

Renaming library items 289

Deleting library items 290

Detaching library items 290

Copying a library item from one site to another 291

Re-creating library items 291

Understanding Server-Side Includes 292

Creating and Inserting Server-Side Includes 293

Creating a server-side include 294

Inserting a server-side include 295

Editing Server-Side Includes 297

Chapter 4: Creating Code Snippets and History Panel Commands... 299

Understanding What Snippets Do 300

Using Dreamweaver's Snippets 300

Creating Code Snippets 301

Creating a text snippet 302

Creating a JavaScript snippet 304

Creating a snippet with the Wrap Selection option 306

Creating a snippet with graphics 309

Working with Snippets 311

Sharing snippets 311

Editing snippets 312

Deleting snippets 312

Managing snippets 312

Creating History Panel Commands 313

Working with the History Panel 313

Recording commands 314

Playing commands 315

Renaming and deleting commands 317

Chapter 5: Integrating Dreamweaver with Fireworks 319

Preparing to Work with Dreamweaver and Fireworks 320

Setting Fireworks launch-and-edit preferences 320

Optimizing Dreamweaver for use with Fireworks 322

Using Fireworks Images in Dreamweaver 324

Inserting a Fireworks image in a Dreamweaver document 324

Replacing an image placeholder with a Fireworks graphic 325

Editing Images in Fireworks Tables 328

Optimizing Your Images in Dreamweaver 330

Page 9: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

jClfitt DreamWeaver CS5 A(Mn-One For Dummies

Using Fireworks HTML in Dreamweaver 331

Inserting Fireworks HTML in a Dreamweaver document 332

Pasting Fireworks HTML in a Dreamweaver document 333

Updating Fireworks HTML in a Dreamweaver Document 334

Editing Fireworks Pop-Up Menus 335

Roundtrip pop-up menu editing (Fireworks 8 and later) 335

Pop-up menu editing (Fireworks MX 2004 and earlier) 336

Chapter 6: Dreamweaver Cross-Application Integration 337

Working with Adobe Flash 338

Inserting and Optimizing Photoshop Graphics 339The Smart Objects workflow 340The Copy/Paste workflow 344

Accessing and Using Adobe Bridge 346

Launching Bridge from Dreamweaver 347

Launching Dreamweaver from Bridge 347

Inserting a file from Bridge 347

Integrating Your Files with Device Central 347

Setting Up Dreamweaver to Use Adobe AIR 349

Working with Adobe's Creative Suites Extended Services (CSXS) 350

Share My Screen (ConnectNow) 351

Search for Help 352

Third-Party Flash-based Services 354

Managing Your CSXS Services 354

Book If/: Energizing four Site 357

Chapter 1: Working with Layers 359

Understanding Layers 360

Creating Layers 363

Drawing an AP Div layer 363

Adding content to layers 364

Creating nested layers 364

Setting layer preferences 366

Managing AP Div Layers with the AP Elements Panel 367

Preventing layer overlap 368

Naming AP Div layers 369

Changing the z-index (stacking order) 369

Editing layer visibility 369

Selecting and Adjusting AP Div Layers 370

Selecting layers 371

Resizing and moving AP Div layers 372

Setting Layer Properties 372

Controlling Layer Style and Positioning with CSS 375

Controlling Layers with Behaviors 378

Converting AP Divs to Tables and Tables to AP Divs 378

Converting AP Div layers to a table 379

Converting tables to AP Div layers 381

Page 10: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

4

Tabte of Contents XIX

Chapter 2: Jazzing Up Pages with JavaScript Behaviors

and Spry Widgets 363

Understanding JavaScript Behaviors 385

Adding JavaScript to Your Page 386

Using Dreamweaver's Default Behaviors 389

Using the Behaviors panel 389

Attaching a behavior 390

Changing and deleting behaviors 391

Updating old behaviors 392

Call JavaScript Behavior 393

Change Property Behavior 394

Check Plugin Behavior 395

Drag AP Element Behavior 397

Spry Effects Behaviors 400

Go to URL Behavior 403

Jump Menu and Jump Menu Go Behaviors 405

Creating a jump menu 405

Editing the Jump Menu behavior 407

Adding and removing a Go button 407

Open Browser Window Behavior 408

Popup Message Behavior 411

Preload Images Behavior 413

Set Text of Container Behavior 414

Set Text of Frame Behavior 416

Set Text of Status Bar Behavior 417

Set Text of Text Field Behavior 418

Show-Hide Elements Behavior 420

Swap Image Behavior 422

Swap Image Restore Behavior 424

Validate Form Behavior 425

Using Third-Party Behaviors 425

Visiting the Adobe Exchange Web site 425

Using the Extension Manager 426

Working with Spry Widgets 428

Chapter 3: Designing Pages with Frames 433

Understanding Frames 434

Creating Frames and Framesets 436

Using predefined framesets to create a new file 438

Displaying a file in a predefined frameset 439

Creating custom framesets 440

Adding, Removing, and Resizing Frames 441

Adding frames 441

Removing frames 442

Resizing a frame 442

Nested Framesets 442

Opening Pages in a Frame 444

Page 11: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Qreamuteai/er CS5 Mt-'m-Om For dummies

Saving Frames and Framesets 445

Saving all the files in the frameset 445

Saving only the frameset file 446

Saving an individual file in a frame 447

Titling a Frameset 447

Setting the Background Color of a File in a Frame 448

Setting Frame Properties with the Properties Inspector 448

Setting frameset properties 449

Setting frame properties 451

Frame Accessibility Settings 452

Setting accessibility preferences 453

Adding or editing accessibility settings to a frame

with the Tag Editor 453

Targeting Frames with Links 454

Adding Noframes Content 455

Creating Floating Frames 457

Chapter 4: Making Your Pages XHTML-Compliant 463

Understanding the Benefits of Using XHTML with Dreamweaver 463

Getting the Basics of XHTML Syntax 464

Discovering the strict rules you can't live without 464

Taking advantage of strict and transitional rules 465

Handling Dreamweaver's Automatic XHTML Code Compliance Tools ...466

Making Sure Your Documents Follow XHTML Syntax 470

Creating a new XHTML document with Dreamweaver 470

Changing the default DTD 470

Transforming HTML document code into XHTML 471

Converting existing HTML files to XHTML 472

Making sure your HTML file can be converted to XHTML 472

Validating Your XHTML 472

Book V: Publishing j/our Site 473

Chapter 1: Using Reports to Test Your Site before Publishing 475

Testing Your Site 476

Following general testing guidelines 476

Previewing your pages in multiple browsers 477

Setting the primary and secondary browsers 477

Previewing pages in multiple browsers locally 479

Previewing pages in Adobe BrowserLab 480

Setting download times and size 481

Examining the Results Panel 483

Searching Your Code for Tags and Attributes 484

Looking Up Reference Information 484

Validating Your Code 484

Using the Validation tab 485

Setting Validation tab preferences 486

Page 12: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

*

Table of Contents KM

Testing Your Pages with Browser Compatibility 487

Setting the target browsers for Browser Compatibility 488

Using the Browser Compatibility tab 489

Viewing and fixing errors 491

Checking and Fixing Links 492

Handling Workflow and HTML Reports 494

Launching reports 494

Saving reports as XML files 497

Viewing File Transfer Activity with the FTP Log 498

Debugging a ColdFusion Application (Windows) 498

Chapter 2: Keeping Your Code Clean 501

Eliminating Formatting Issues Before They Occur 502

Setting Copy and Paste preferences 502

Using the Paste Special command 504

Cleaning up Word HTML 504

Checking Your Spelling, Grammar, and Readability 506

Getting Your HTML and XHTML Code Consistent 508

Reviewing Source Formatting and Making Changes 510

Setting code lormatt'mg preferences 510

Introducing your Code Category preferences 510

Applying Source Formatting 514

Applying source formatting to a complete file 514

Applying source formatting to a selection 515

Using the JavaScript Extractor (JSE) 515

Changing Links Sitewide 517

Chapter 3: Preparing to Publish Your Files Online 519

Creating a Remote Connection 519

Setting up a remote folder 520

Configuring a connection type 522

Cloaking Your Files and Folders 531

Enabling and disabling cloaking options 532

Cloaking individual folders 533

Uncloaking previously cloaked file types 534

Chapter 4: Publishing Your Web Pages Online 535

Understanding File Transfer Basics 535

Transferring dependent files 536

Working during file transfers 536

Putting Files on and Getting Files from the Remote Server 537

Examining the Files panel transfer options 538

Putting files on a remote server 540

Getting files from a remote server 542

Viewing the FTP and background file activity logs 542

Keeping Your Local and Remote Site Files Up-to4Date 544

Viewing the newest files without synchronization 544

Synchronizing your files 545

Page 13: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

XXti breaimi'eai'er CSS AH-in-One For Dummies

Book (/I: Workinq Collaboratively 5k9

Chapter 1: Working Efficiently with a Team 551

Attaching Design Notes to Your Files 551

Enabling and disabling Design Notes 553

Removing Design Notes 554

Adding Design Notes to a file 554

Viewing and editing Design Notes 556

Checking Files In and Out 557

Using Version Control with Subversion 559

Denning File View Columns 561

Customizing File View Columns 561

Sorting File View Columns 563

Chapter 2: Setting Up and Connecting to a Contribute Site 565

Understanding Contribute Best Practices 566

Making a Dreamweaver Site Connection Compatible with Contribute...567

Using Dreamweaver to Administer a Contribute Site 569

Making the Most of Templates 572

Leaving a Trail of Bread Crumbs for Contribute Users 574

Connecting to a Contribute Site 574

Transferring files to and from a Contribute

site from within Dreamweaver 575

Setting Contribute file and folder permissions 576

Understanding Contribute Special Files 576

Troubleshooting a Contribute Site in Dreamweaver 577

Fixing connection problems 577

Checking the _mm folder 578

Chapter 3: Managing a Contribute Site 581

Managing Contribute Files Using Dreamweaver 582

Rolling back your files 583

Making changes to Contribute files 585

Enabling Contribute users to use templates 586

Unlocking a checked out file 587

Using Dreamweaver to Edit a Contribute Site 588

Updating templates in a Contribute site 588

Editing style sheets in a Contribute site 588

Chapter 4: Collaborating Online with InContext Editing 591

Creating and Managing Editable Regions 592

Creating editable regions 592

Creating repeating regions 595

Deleting editable regions 596

Preparing a Site for Use with InContext Editing 597

Inviting Users to the Site 598

Updating Pages with InContext Editing 598

Page 14: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Table of Contents KRtU

Book V\h Building Web Applications 601

Chapter 1: Preparing to Build Web Applications 603

Understanding Web Applications 603

Choosing a Web Application Platform 605

Choosing a Web Server 605Hosted sites 605

Hosting your own site 606

Choosing an Application Server 608

PHP 608

Active Server Pages (ASP) 610

ASP.NET 610

Java Server Pages (JSP) 610

ColdFusion 611

Considering Web/Application Server Combinations 611

Setting Up the Testing Server in Dreamweaver 612

Introducing Databases 614

Choosing a Database 615

Chapter 2: Configuring MySQL Database Connections for PHP...

.617

Adding a PHP Database Connection 617

Creating a new dynamic PHP page 617

Creating the database connection for PHP 619

Editing a PHP Database Connection 622

Deleting a PHP Database Connection 622

Chapter 3: Configuring ASP Database Connections 625

Understanding ASP Database Connections 625

Creating a New ASP Page 626

Connecting to a Database with a Data Source Name (DSN) 627

Connecting to a Database with a Custom Connection String 629

Connecting to a Remote Database without a DSN 631

Understanding physical paths and virtual paths 631

Finding the database's physical path when you know

the virtual path 631

Connecting to a remote database with a virtual path 632

Editing an ASP Database Connection 633

Deleting an ASP Database Connection 633

Chapter 4: Configuring ASP.NET Database Connections 635

Exploring ASP.NET Database Connections 635

Creating a New ASP.NET Page 636

Building an OLE DB Connection 637

Using templates 637

Using data link properties 639

Building an SQL Server Connection 639

Editing an ASP.NET Database Connection 640

Deleting an ASP.NET Database Connection 641

Page 15: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

DreamWeaver CS5 MMn*One For dummies

Chapter 5: Configuring JSP Database Connections 643

Gathering Database Connection Information 643

Adding a JSP Database Connection 644

Java Runtime Environment installation 645

Installing the JDBC driver 645

Creating a New JSP Document 646

Connecting to a Database 647

Editing a JSP Database Connection 648

Deleting a JSP Database Connection 649

Chapter 6: Configuring ColdFusion Database Connections 651

Pulling Together Database Connection Information 651

Understanding How ColdFusion Connects to Databases 652

Adding a ColdFusion Database Connection 652

Creating a new ColdFusion document 653

Specifying RDS login information 653

Configuring a database connection with the ColdFusion

Administrator 654

Configuring a database connection in Dreamweaver 656

Editing a ColdFusion Database Connection 657

Using Dreamweaver 657

Using ColdFusion Administrator 658

Deleting a ColdFusion Database Connection 659

Chapter 7: Dealing with Database Problems and Other Gotchas.. .661

Troubleshooting Basic Database Access 662

Verifying contact with the database server 662

Validating your database username and password 663Problematic Permissions: IIS and File-Based Databases 664

Troubleshooting Microsoft Error Messages 66680004005: Data source name not found 667

80040e07: Data type mismatch in criteria expression 66780040el0: Too few parameters 667

80040el4: Syntax error in INSERT INTO statement 668

80040e21: ODBC error on Insert or Update 668800a0bcd: Either BOF or EOF is true 668

Troubleshooting JSP Database Connections 668

Identifying Problems in the Database 668

General Troubleshooting 669

Book (/111: Making Pages Dynamic 671

Chapter 1: Preparing Dynamic Content Sources 673

Exploring Your Database in the Databases Panel 674

Defining Form Parameters 675

Defining URL Parameters 677

Page 16: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

Table of Contents

Defining Session Variables 679

Using a Database as Your Data Source 681

Understanding recordsets 681

Defining a recordset 681

Chapter 2: Using Dynamic Content in YourWeb Pages 685

Displaying and Formatting Dynamic Content 685

Adding dynamic text 686

Formatting your dynamic content 687

Testing your dynamic text 688

Working with Database Recordsets 690

Repeating regions on your page 690

Repeating regions in HTML tables 692

Adding a recordset navigation bar 694

Showing and hiding regions on your page 696

Adding Dynamic Form Elements to Your Page 697

Chapter 3: Previewing and Testing Your Dynamic Pages 699

Viewing Live Data in Your Dynamic Web Pages 699

Understanding how Live View works 699

Uploading dependent files to the testing server 701

Providing parameters for user input 703

Troubleshooting problems in Live Data mode 704

Previewing a Dynamic Web Page in Your Browser 705

Chapter 4: Building Dynamic Forms 709

Inserting Text Fields 709

Adding Check Boxes 711

Working with Radio Buttons 713

Inserting Lists and Menus 714

Chapter 5: Advanced Dynamic Data Presentation 717

Using ColdFusion Components 717

Building Web pages that use ColdFusion Components 718

Creating ColdFusion Components 720

Creating Custom Server Behaviors 723

Book IK: Developing Applications Rapidly 729

Chapter 1: Building Master and Detail Pages 731

Building Master and Detail Pages in One Operation

(PHP, ASP, JSP, ColdFusion) 732

Developing Master and Detail Pages Block by Block 736

Creating the master page 736

Setting up links to open a detail page 737

Building detail pages 739

Page 17: Dreamweaver CS5 all-in-one for dummies : [9 books in 1 ... · Dreamweaver®CSS ALL-IN-ONE FOR DUMHIE&' bySueJenkinsandRichardWagner WILEY WileyPublishing,Inc

XKtfl Dreamweaver CS5 All-in-One For dummies

Developing Master and Detail Pages for ASP.NET 742

Creating a master page 742

Creating links that open the detail page 742

Creating a detail page 744

Testing Your Master and Detail Pages 744

Chapter 2: Creating Search and Results Pages 747

Creating the Search Page 747

Building the Results Page 750

Building the recordset 750

Displaying the results 753

Testing Your Search and Results Pages 754

Chapter 3: Building Record Insert Pages and

Restricting Site Access 757

Creating the Record Insert Page in One Operation 758

Building a Record Insert Page Block by Block 761

Adding the form 761

Adding the Insert Record server behavior 762

Testing Your Record Insert Page 765

Building a Login Page 766

Setting up a database table 767

Creating the HTML form on the login page 767

Adding a Log In User server behavior to the page 767

Restricting Access to Your Pages 768

Chapter 4: Developing Record Update and Delete Pages 771

Building an Update Page 771

Creating link to the update page 772

Putting the update page together 774

Testing Your Update Page 779

Building Pages to Delete a Record 781

Creating delete links to open the confirmation page 782

Defining the URL parameter to pass to the confirmation page.... 782

Building the confirmation page 784

Adding logic to delete the record 787

Testing Your Delete Page 788

index. 791