ColdFusion MX Bible

1250 Pages·2003·9.518 MB·English

by  Adam Phillip Churvis, Hal Helms, Charlie Arehart, David Churvis

P5e4r6f2e2c8t CBoivnedr • 1/T2r2i/m0:3 7 132/:82 6x P9M 1 /P4a g•e 1
• 4 color process • Yellow prints 110y 15m • + spot varnish (see spot varnish pdf) • Matte laminate
If ColdFusion MX can do it, you can do it too . . . 100% 100%
As e-business continues to grab market share, you’re continually challenged to create faster, cheaper, and more
reliable e-commerce Web applications. ColdFusion MX offers the quickest, most reliable way to build and deploy C O M P R E H E N S I V E ONE HUNDRED PERCENT
COMPREHENSIVE
them, and this comprehensive reference guides you from writing your first application all the way through the CC
AUTHORITATIVE
complexitiesofintegratingwithWebservices,Flash,Java,COM,andXML.Frominstallationtodatabaseconnection WHAT YOU NEED
configuration, from tag and function usage to code reuse, it’s like having your personal team of experts on call. ONE HUNDRED PERCENT
oo
Inside, you’ll find complete coverage of ColdFusion MX
ll Invigorate your
• Create highly interactive, database-driven Web sites with ColdFusion’s intuitive, dd Web sites with
tag-based programming language ColdFusion’s rich
Logical Data Model (LDM) Physical Data Model (PDM) FF
• Build and deploy content publishing systems, online stores, business reporting IPDUItnaenevrmisteecPNnnrrtituipoIcmttreeiyobmInetNermumberNVVVAAAURRRMCCCEHHHRAAAICRRR((((11412505,)))2)NNNOOOTTT NNNNUUUULLLLLLLL IIPDUnteaenvmrsietecPnNnrrtituoipIcmtrteeyiobmItneeNrm u(PmKb)ervvvnaaaurrrmcccehhhraaairrrc((((11415502))),2) NNNOOOTTT NNNNUUUULLLLLLLL development
applications, self-service solutions, and more uu language
CategoryInventoryItem
• Easily create and use Web services and ColdFusion Components CItaetmeNgourmyCboedr e(P (KP)K(F)(KF)K)vvaarrcchhaarr((41)5)NNOOTT NNUULLLL
• Integrate applications with other technologies like Java, COM, and XML CCaatteeggoorryyCode VARCHAR(4)NOT NULL Category ss Activate the power
CategoryName VARCHAR(20)NOT NULL CCaatteeggoorryyCNoadmee (PK)vvaarrcchhaarr((42)0) NNOOTT NNUULLLL of ColdFusion to
• Learn how — and why — to document your code, handle source ii
oo build more robust
version control, and integrate security, testing, and performance
Learn database modeling,
applications
• Discover how to use ColdFusion with databases, Web services, triggers, and stored procedures nn
and Flash Remoting Integrate CFMX
• Extend ColdFusion applications with features like task MCoolddFeul sLiaoyne Cromponents Company.cfc 4 ®® with powerful
scheduling, file operations, Verity text searching, and charting <<c/cf<<<ffcccufufffnaqrnceructgteituoiurornmynn nn>ecaanommtm neepa==Rm""Gececoe=>mt"CCpooRmmepcpa"a n.n.y.y>"I rD..e."<t tu/ycrpnfqetyu=pe"neruy=m>"qeureicry" "r eaqcuciersesd==""ryeems"o>te"> MM technologies like
CFloansthr oRlelemr oLtainyge rGateway 3Grc(Ceoaqomtumepewpasaant nyyw y rIi.oDtchuf tctoe) .s.G .e .tCompany() 5Grc(FeoalsmatpespowhRnManeysoc erv to ioweu ).ti .te.Gh s.etCompany_Result() Create a complete Flash, JSP, XML,
VFliaeswh LMaoyveire2AGgacettteiCowonmaSycprainpyt (gceotmCopmanpyaInDy)( i)n calls Flash Remoting
• DTraiBatalo Fvnaecrutsosiroy n,Cs L DooRf- RCAAdOTa,M lSoonu DrceevOeflfoSpiteer, Eadnidti oMna, cCroommmedeirac eCBollodcFkuss,i on .T..haiCCACSZnsdi hoitdipta somytd th C:oorepienoss:a esedins s evCy :ai: eo Nswmea cpemoaleennmd:y ev:niet.w.. eleAA1AG3m20BBtA33leaCC40nn 3 tMCC.taooamminpp aaSnntryye,, eIInntcc.. 16UtffFfwruuulsiahnnngcacszesicccgictodirhpaittte homdiiyc Ctoomr nr_ehsiponnes t_oo gad xc sGptvroenestxheio.seet_y_ttacCpee.tN'tttneCsuxxsoxegai o lttmtxvGca..em mttet=otepee edhe= pmtaxcxsC a_ aantcotp not mnsy=om=xadmy ( m toan)cpcl_.eptvnyopaoRerai, manme xoewnny tbsppfy Rhyiu=j_aaeeRiel cRnnltccdec(hyyeotcsco RRsmno orfueedamrrplccod.mtaipsoomt.ineea(rrt) deymddnr ARe.m. yisictttRce[eseou0tce[mmmri]0oocn.]Csspnroe.d[S[iaSrd0t0.dtynci ]]atr).;.yreAZe t{iRempicdpe;todsCcrr[odo0ed],rs.deCs;;ompanyName; application XX and CCCOM oollddFFuussiioonn MMXX
Server MX, plus other software
• Author files, code listings and samples, and real-world
®®
applications you can use
CHURVIS, HELMS,
• Searchable e-version of the book
AREHART, & CHURVIS
Companion Web site
at www.wiley.com/compbooks/churvis
provides code samples, useful links, Bible
w w w . w i l e y . c o m / c o m p b o o k s /
and more
System Requirements: $49.99 USA Reader Level: Shelving Category:
PC running Windows 98, Windows 2000, $74.99 CANADA Beginning to Advanced Internet / Web Site Design
Windows NT4 (SP6a or later) or Windows XP. £37.50 UK Trial software
See the What’s on the CD-ROM Appendix for and code listings
on CD-ROM
details and complete system requirements. ISBN 0-7645-4622-8
*85555-ABJGHg ,!7IA7G4-fegcci!:p;o;t;T;T
BONUS CD-ROM AND
COMPANION WEB SITE
Adam Phillip Churvis, Hal Helms,
Software samples on CD-ROM
Charles Arehart, and David Churvis
plus more resources online

546228 FM.F 1/31/03 3:07 PM Page i
ColdFusion® MX
Bible
546228 FM.F 1/31/03 3:07 PM Page ii
546228 FM.F 1/31/03 3:07 PM Page iii
ColdFusion® MX
Bible
Adam Phillip Churvis, Hal Helms,
Charles Arehart, David Churvis
546228 FM.F 1/31/03 3:07 PM Page iv
ColdFusion®MX Bible
Published by
Wiley Publishing, Inc.
909 Third Avenue
New York, NY 10022
www.wiley.com
Copyright © 2003 by Wiley Publishing, Inc., Indianapolis, Indiana
Library of Congress Number: 2001093600
ISBN: 0-7645-4622-8
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
1B/SQ/QS/QT/IN
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means,
electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of
the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through
payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978)
750-8400, fax [phone]. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley
Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, [phone], fax [phone], E-Mail:
[email protected].
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: WHILE THE PUBLISHER AND AUTHOR HAVE USED THEIR BEST
EFFORTS IN PREPARING THIS BOOK, THEY MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE
ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS BOOK AND SPECIFICALLY DISCLAIM ANY IMPLIED
WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED
OR EXTENDED BY SALES REPRESENTATIVES OR WRITTEN SALES MATERIALS. THE ADVICE AND STRATEGIES
CONTAINED HEREIN MAY NOT BE SUITABLE FOR YOUR SITUATION. YOU SHOULD CONSULT WITH A
PROFESSIONAL WHERE APPROPRIATE. NEITHER THE PUBLISHER NOR AUTHOR SHALL BE LIABLE FOR ANY LOSS
OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED TO SPECIAL, INCIDENTAL,
CONSEQUENTIAL, OR OTHER DAMAGES.
For general information on our other products and services or to obtain technical support, please contact our Customer
Care Department within the U.S. at 800-762-2974, outside the U.S. at 317-572-3993 or fax [phone].
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in
electronic books.
Trademarks:Wiley, the Wiley Publishing logo and related trade dress are trademarks or registered trademarks of Wiley
Publishing, Inc., in the United States and other countries, and may not be used without written permission. ColdFusion is a
trademark or registered trademark of Macromedia, Inc. in the United States and/or other countries. All other trademarks
are the property of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned
in this book.
is a trademark of Wiley Publishing, Inc.
546228 FM.F 1/31/03 3:07 PM Page v
About the Authors
Adam Churvisis a database and scalability specialist with more than 20 years of
software-industry experience in many languages and database platforms. He is the
founder and President of Productivity Enhancement, a full-service consulting, train-
ing, and commercial-software development firm, which is entering its 18th year in
business and is also the parent company of ColdFusionTraining.com, which pro-
vides the most advanced and intensive ColdFusion training in the world. Adam is a
member of Team Macromedia and also serves as a current board member and for-
mer President of the Atlanta ColdFusion User Group, and he enjoys speaking at
other CFUGs as well. He has a wife, whom he worships, three children, three cats,
and lots and lots of computers. He can be reached at
[email protected].
Hal Helms is an internationally-known speaker, writer, and trainer on Java,
ColdFusion, and best practices in software development. Hal writes the popular
“Occasional Newsletter” available at halhelms.com, and you can reach him at
[email protected].
Charles Arehartis the founder and CTO of SysteManage, based in Laurel,
Maryland. A Macromedia certified advanced developer and instructor, Charles
is also a member of Team Macromedia who has logged more than 5 years with
ColdFusion and more than 20 years in IT. His monthly “Journeyman” column
appears in ColdFusion Developer’s Journal, where he’s a technical editor. He is a
regular speaker at developer conferences, seminars, and user group meetings
worldwide, and also provides training and short-term consulting. You can reach
him at [email protected].
David Churvisis a software-development specialist who got his start in object-
oriented programming at the age of eight. He has worked in HyperCard, SuperCard,
FutureBasic, CFML, VTML/WIZML, Transact/SQL, PL/SQL, Delphi, C, C++, C#, Java,
JSP, JavaScript, VBScript, and DHTML. David is Vice President of Development for
Productivity Enhancement and is the chief programmer behind the CommerceBlocks
line of modular ColdFusion development tools and LoRCAT, the Load Reduction and
Concentration Analysis Tool for ColdFusion.
546228 FM.F 1/31/03 3:07 PM Page vi
Credits
Senior Acquisitions Editor Executive Editorial Director
Sharon Cox Mary Bednarek
Project Editor Project Coordinator
Sharon Nash Nancee Reeves
Technical Editor Graphics and Production Specialists
Jen and Peter deHaan Melissa Auciello-Brogan, Beth Brooks,
Jennifer Click, Joyce Haughey,
Copy Editor Stephanie D. Jumper, Jeremey Unger
William A. Barton
Quality Control Technician
Editorial Manager Susan Moritz, Charles Spencer
Mary Beth Wakefield
Permissions Editor
Vice President and Executive Carmen Krikorian
Group Publisher
Richard Swadley Media Development Specialist
Travis Silvers
Vice President and Executive
Publisher Proofreading and Indexing
Bob Ipsen TECHBOOKS Production Services
546228 FM.F 1/31/03 3:07 PM Page vii
Adam Churvis: This book is dedicated to my uncle, Lionel Bernard Watkins II, and to
the Marine Military Academy, for teaching me the most important Code of all. Semper
Fidelis, Marines.
Hal Helms: To Stan Cox, whose ideas never fail to inspire me.
Charles Arehart: Begin to weave and God will give you the thread – German Proverb.
David Churvis: I dedicate this book to Anne Granville, Neil Nichols, Pat Greeson, and
Ed Coleman, the best schoolteachers I ever had. Thanks for never accepting anything
less than my best and thanks for always believing in me.
546228 FM.F 1/31/03 3:07 PM Page viii