Table Of Content

Mastering™ Dreamweaver™ MX Databases Susan Sales Harkins Bryan Chamberlain Darren McGee SYBEX® The Scripting Tools Dreamweaver MX is a powerful tool for building web applications visually, and it supports a wide variety of scripting languages and environments, including ColdFusion, Active Server Pages, ASP.NET, ADO.NET, JSP, and PHP—and the fundamental database language, SQL. If you’ve worked with any of these languages and need to add another one to your skill set, Mastering Dreamweaver MX Databases will give you enough of the essentials to get started. Or, if you have the opportunity to choose which language to use for a project, you can use these chapters to compare features and make an informed, appropriate choice. See Chapters 11 through 16, and 18. Working with Data (and Securing It) Finally, Mastering Dreamweaver MX Databases shows how to secure your data and how to handle the essential data-manipulation tasks—retrieving, searching, and updating data. In this section, you’ll also learn how to use templates and create master/detail page sets to both reduce your workload and give all the pages of your site a uniform look, and you’ll be introduced to the add-in extension tools available through the Macromedia Exchange website. See Chapters 17, and 18 through 24. This Page Intentionally Left Blank Mastering Dreamweaver MX Databases This Page Intentionally Left Blank Mastering ™ Dreamweaver MX Databases ™ Susan Sales Harkins Bryan Chamberlain Darren McGee San Francisco London Associate Publisher: Dan Brodnitz Acquisitions Editor: Willem Knibbe Developmental Editor: James A. Compton Production Editor: Leslie E.H. Light Technical Editor: Lucinda Dykes Copyeditor: Pat Coleman Compositor: Interactive Composition Corporation—Rozi Harris Graphic Illustrator: Interactive Composition Corporation—Rozi Harris CD Coordinator: Dan Mummert CD Technician: Kevin Ly Proofreaders: Amey Garber, Emily Hsuan, Laurie O’Connell, Laura Schattschneider, Yariv Ravinovitch, Nancy Riddiough, Monique van den Berg Indexer: Nancy Guenther Book Designer: Maureen Forys, Happenstance Type-O-Rama Cover Designer: Design Site Cover Illustrator/Photographer: Sergie Loobkoff Copyright © 2003 SYBEX Inc., 1151 Marina Village Parkway, Alameda, CA 94501. World rights reserved. The author(s) created reusable code in this publication expressly for reuse by readers. Sybex grants readers limited permission to reuse the code found in this publication or its accompanying CD-ROM so long as the author(s) are attributed in any application containing the reusable code and the code itself is never distributed, posted online by electronic transmission, sold, or commercially exploited as a stand-alone product. Aside from this specific exception concerning reusable code, no part of this publication may be stored in a retrieval system, transmitted, or reproduced in any way, including but not limited to photocopy, photograph, magnetic, or other record, without the prior agreement and written permission of the publisher. Library of Congress Card Number: 2002115470 ISBN: 0-7821-4148-X SYBEX and the SYBEX logo are either registered trademarks or trademarks of SYBEX Inc. in the United States and/or other countries. Mastering is a trademark of SYBEX Inc. Screen reproductions produced with FullShot 99. FullShot 99 © 1991–1999 Inbit Incorporated. All rights reserved. FullShot is a trademark of Inbit Incorporated. The CD interface was created using Macromedia Director, COPYRIGHT 1994, 1997–1999 Macromedia Inc. For more information on Macromedia and Macromedia Director, visit http://www.macromedia.com. Internet screen shot(s) using Microsoft Internet Explorer 6 reprinted by permission from Microsoft Corporation. TRADEMARKS: SYBEX has attempted throughout this book to distinguish proprietary trademarks from descriptive terms by following the capitalization style used by the manufacturer. The author(s) and publisher have made their best efforts to prepare this book, and the content is based upon final release software whenever possible. Portions of the manuscript may be based upon pre-release versions supplied by software manufacturer(s). The author and the publisher make no representation or warranties of any kind with regard to the completeness or accuracy of the contents herein and accept no liability of any kind including but not limited to performance, merchantability, fitness for any particular purpose, or any losses or damages of any kind caused or alleged to be caused directly or indirectly from this book. Manufactured in the United States of America 10 9 8 7 6 5 4 3 2 1 Software License Agreement: Terms and Conditions The media and/or any online materials accompanying this book that Warranty are available now or in the future contain programs and/or text files SYBEX warrants the enclosed media to be free of physical defects for (the “Software”) to be used in connection with the book. SYBEX a period of ninety (90) days after purchase. The Software is not avail- hereby grants to you a license to use the Software, subject to the terms able from SYBEX in any other form or media than that enclosed that follow. Your purchase, acceptance, or use of the Software will herein or posted to www.sybex.com. If you discover a defect in the constitute your acceptance of such terms. media during this warranty period, you may obtain a replacement of The Software compilation is the property of SYBEX unless otherwise identical format at no charge by sending the defective media, postage indicated and is protected by copyright to SYBEX or other copyright prepaid, with proof of purchase to: owner(s) as indicated in the media files (the “Owner(s)”). You are hereby granted a single-user license to use the Software for your SYBEX Inc. personal, noncommercial use only. You may not reproduce, sell, dis- Product Support Department tribute, publish, circulate, or commercially exploit the Software, or 1151 Marina Village Parkway any portion thereof, without the written consent of SYBEX and the Alameda, CA 94501 specific copyright owner(s) of any component software included on Web: http://www.sybex.com this media. After the 90-day period, you can obtain replacement media of identical In the event that the Software or components include specific license format by sending us the defective disk, proof of purchase, and a check requirements or end-user agreements, statements of condition, dis- or money order for $10, payable to SYBEX. claimers, limitations or warranties (“End-User License”), those End-User Licenses supersede the terms and conditions herein as to Disclaimer that particular Software component. Your purchase, acceptance, or use of the Software will constitute your acceptance of such End-User SYBEX makes no warranty or representation, either expressed Licenses. or implied, with respect to the Software or its contents, quality, performance, merchantability, or fitness for a particular purpose. In no By purchase, use or acceptance of the Software you further agree to event will SYBEX, its distributors, or dealers be liable to you or any comply with all export laws and regulations of the United States as other party for direct, indirect, special, incidental, consequential, such laws and regulations may exist from time to time. or other damages arising out of the use of or inability to use the Soft- Reusable Code in This Book ware or its contents even if advised of the possibility of such damage. In the event that the Software includes an online update feature, The author(s) created reusable code in this publication expressly SYBEX further disclaims any obligation to provide this feature for any for reuse by readers. Sybex grants readers limited permission to reuse specific duration other than the initial posting. the code found in this publication, its accompanying CD-ROM or The exclusion of implied warranties is not permitted by some states. available for download from our website so long as the author(s) are Therefore, the above exclusion may not apply to you. This warranty pro- attributed in any application containing the reusable code and the code vides you with specific legal rights; there may be other rights that you itself is never distributed, posted online by electronic transmission, may have that vary from state to state. The pricing of the book with the sold, or commercially exploited as a stand-alone product. Software by SYBEX reflects the allocation of risk and limitations on liability contained in this agreement of Terms and Conditions. Software Support Shareware Distribution Components of the supplemental Software and any offers associated with them may be supported by the specific Owner(s) of that material, This Software may contain various programs that are distributed as but they are not supported by SYBEX. Information regarding any shareware. Copyright laws apply to both shareware and ordinary com- available support may be obtained from the Owner(s) using the infor- mercial software, and the copyright Owner(s) retains all rights. If you try mation provided in the appropriate read.me files or listed elsewhere on a shareware program and continue using it, you are expected to register the media. it. Individual programs differ on details of trial periods, registration, and Should the manufacturer(s) or other Owner(s) cease to offer support payment. Please observe the requirements stated in appropriate files. or decline to honor any offer, SYBEX bears no responsibility. This Copy Protection notice concerning support for the Software is provided for your information only. SYBEX is not the agent or principal of the Owner(s), The Software in whole or in part may or may not be copy-protected and SYBEX is in no way responsible for providing any support for the or encrypted. However, in all cases, reselling or redistributing these Software, nor is it liable or responsible for any support provided, or files without authorization is expressly forbidden except as specifically not provided, by the Owner(s). provided for by the Owner(s) therein. To Lexie—the reason I stay in this line of work. —SH I dedicate the part I played in this book to my wife, Sandy, and my children, Jacob and Rachel. You provide me with motivation, strength, hope, and happiness. Thank you. —BC My portion of this book is dedicated to Jay, my family (immediate and extended), and my friends who, over the years and most recently, showered me with faith, encouragement, patience, and support. Without all of you, I wouldn’t have been able to write this—and, specifically, to you, Aunt Opal. I love you all. Also, to Mrs. Bain, Mrs. Unthank, Mrs. Cole, and Jim Moreton. You inspired me more than you’ll ever know. —DM Acknowledgments Thanks to Bryan andDarren for stepping in at the last minute, thanks to Sybex for staying with the book even when the project seemed impossible, and thanks to The Cobb Group editors for teaching me such an interesting marketable skill. —Susan Harkins I wish to thank Susan Harkins and Sybex for the opportunity to create this book. To The Cobb Group for providing such a great environment to learn and grow so much during my time there. I also wish to acknowledge that light is both a wave and a particle and that fast-food fries are much better while you are still in the car. —Bryan Chamberlain First and foremost, I’d like to thank Susan Harkins for her guidance and leadership on this project. Thanks to the folks at Sybex, too, for all your help and having patience with this hectic schedule. Special thanks to Troy Compton for his expert advice and additions to this book—KATE MIPS never fails! And thanks to those of you who find this book useful. —Darren McGee As a team, we’d also like to thank Macromedia, Inc., and particularly Heather Hollaender, for providing software that we used in writing the book, and for letting us distribute trial versions of MX software on the companion CD-ROM. Thanks also to Mariann Barsolo of Sybex, for coordinating the software, and to the Sybex CD team of Keith McNeil, Dan Mummert, and Kevin Ly. Special thanks to Leslie Light of Sybex for managing the book’s production.