BN.com Gift Guide

Mastering ColdFusion 4.5 with CD Rom

( 5 )

Overview


Are you a Web developer interested in building dynamic, interactive Web sites? Are you an application developer looking for a quick, effective way to build applications for the Web? Either way, ColdFusion is for you, and Mastering ColdFusion 4.5 is the resource you need if you want to get the most out of the latest version of this powerful development tool. Written by two ColdFusion experts, this book begins with clear, concise coverage of the basics to help turn newcomers into productive users as quickly as ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (2) from $9.99   
  • Used (16) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$9.99
Seller since 2005

Feedback rating:

(186)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2000 Trade paperback New. No dust jacket as issued. 9.0 x 7.5 x 2.4 inches

Ships from: Camden, DE

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$39.49
Seller since 2014

Feedback rating:

(320)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview


Are you a Web developer interested in building dynamic, interactive Web sites? Are you an application developer looking for a quick, effective way to build applications for the Web? Either way, ColdFusion is for you, and Mastering ColdFusion 4.5 is the resource you need if you want to get the most out of the latest version of this powerful development tool. Written by two ColdFusion experts, this book begins with clear, concise coverage of the basics to help turn newcomers into productive users as quickly as possible. From there, it proceeds to intermediate topics certain to expand your knowledge and skills, and concludes with some of the most advanced ColdFusion instruction you'll find anywhere. Regardless of your experience or needs, you're sure to find what you're looking for.

Coverage Includes

  • Installing and administering the Linux version of ColdFusion
  • Getting data from a database
  • Writing data to a database
  • Including outside code
  • Taking advantage of improved clustering and redundancy support
  • Creating and manipulating variables
  • Using SQL for advanced, dynamic database interaction
  • Creating and validating ColdFusion forms
  • Using the ColdFusion Web application framework
  • Interacting with e-mail, Web, FTP, and LDAP servers
  • Using XML with ColdFusion
  • Implementing error control
  • Using JavaBeans with ColdFusion
  • Scheduling automatic execution of ColdFusion programs
  • Implementing fine-grained, advanced security
  • Creating custom tags
  • Ensuring application security
  • Using WDDX
  • Administering ColdFusion servers
Read More Show Less

Product Details

  • ISBN-13: 9780782127737
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 5/1/2000
  • Series: Mastering Series
  • Edition description: BK&CD ROM
  • Pages: 1104
  • Product dimensions: 7.48 (w) x 9.00 (h) x 2.43 (d)

Meet the Author


Arman Danesh is pursuing an advanced degree in Computer Science at Simon Fraser University in Canada. He has extensive ColdFusion development experience, including developing interactive Internet and Intranet applications for Landegg Academy in Switzerland and managing the Baha'i World Web site, the official Web site of the Baha'i International Community. He has written several books on HTML, JavaScript, and Linux and contributes articles on computer topics to newspapers and magazines throughout Asia.

Kristin Aileen Motlagh is Co-Founder/Director of Technical Solutions for Trilemetry and a member of Team Allaire. She has worked with ColdFusion since version 1.5 and has developed ColdFusion applications for a wide range of corporate clients, including the World Bank, MCI, and GE.

Read More Show Less

Read an Excerpt


Chapter 9: Creating Databases and Tables

In this chapter, you will take a brief look at the process of designing a database and implementing it. The subject of designing relational database models is complex and worthy of one more book of its own. We can't hope to do justice to the subject beyond the smallest glimpse into it; a whole body of theory relates to the design of efficient databases. For most small databases, the best way to learn design is simply by doing it.


NOTE If you would like to learn more about database creation and design, take a look at Sybex's Mastering Access 2000 by Alan Simpson and Celeste Robinson; Access 2000 VBA Handbook by Susann Novalis with Jim Hobuss; and Access 2000 Developer's Handbook, Volume 1: Desktop Edition or Access 2000 Developer's Handbook, Volume 2: Enterprise Edition, both by Paul Litwin, Ken Getz, and Mike Gilbert.

You will design a small contact-management database in this chapter. You will not be creating the user interface to the database, which could be done using ColdFusion, but rather will look at the requirements of the project, and then walk through the decisions that go into designing the back-end database that would support the application. Finally, you will walk through the implementation of the model you have designed using Microsoft Access. The process of implementing database design differs from database to database, and especially between desktop databases and full-scale client-server database systems. Still, the basic approach used inModel

For the purposes of our exercises in this section, you will walk through the design and implementation of a database to act as the back end in a simple contact-management system. The system will need to provide the following functionality:

  • Track a contact's personal information, including name, age, gender, occupation, title, company, address, phone and fax numbers, e-mail address, URL, Social Security number, and customer identification number
  • Ensure that state codes, telephone country codes, telephone area codes, and country names are entered in a standardized fashion
  • Provide the capability to track incoming and outgoing correspondence with a given contact, including the type of correspondence (mail, fax, phone, or e-mail), the date and time of the correspondence, the direction of the correspondence (incoming or outgoing), the filename of the correspondence if it is in electronic form, indication of which other piece of correspondence it is in response to, and asummary of the correspondence

In designing this database, you need to follow several steps:

1. Gather requirements: In this stage, you look at the data you are tracking and any special issues that need to be addressed in this data.

2. Determine tables: Based on the requirements, you need to look at the specific data-base tables that you will create.

3. Assign primary keys: Each table needs a primary key. You will look at the data to be stored in each table to see whether there is a logical primary key, and, if not, consider how to create one.

4. Define columns: For each table you need to define the fields (or columns) to appear in the table, the data type and other limitations on the type of data stored in the field.

5. Make relationships: In the final stage, you specify relationships between tables. The whole idea behind relational database systems is that they leverage relation-ships between sets of data to create complex models of information.

Gathering Requirements and Determining Tables

We have already outlined the basic database requirements in our specification of application requirements. For instance, you know that you need to track personal information about each contact as well as maintain a historical log of correspondence with pointers to actual electronic documents of correspondence. One central issue is left from that definition: ensuring that "state codes, telephone country codes, telephone area codes, and country names are entered in a standardized fashion."

The standard tactic for doing this in a relational database is to maintain separate lists of countries, states, and telephone codes, and then, rather than include the state name or phone code in the personal information, simply point to an item in the list. Because all personal information records simply point to items in these country and state lists, you can ensure that every record uses a consistent spelling for country and state names, and that any required spelling changes need to be done only one place: in the separate list of countries or states.

This does raise one issue, though: It is reasonable to maintain a separate list of all countries and their telephone codes, and all states and provinces in the U.S. and Canada. However, it seems unwieldy to maintain a list of states and provinces in all countries in the world. Therefore, you will also need to provide a way to handle U.S. and Canadian addresses slightly differently from those of other countries. For U.S. and Canadian addresses, the user should be able to select an entry from the list of states and provinces, but for other addresses, the user should be able to manually enter a province or state.

This is a common tactic in many Web sites that ask for addresses in forms. They pro-vide a drop-down list of all states and provinces in Canada and the U.S. This list, however, includes one entry along the lines of Outside the U.S. and Canada and then provides a blank text field that the user can fill in when they choose this option on the drop-down list. This type of form simply reflects the way in which data may be structured in the underlying database.

The question, then, is how all this translates into tables in your database design. You will need the following databases to store the information required by the application:

Info A table for tracking personal information

Countries A list of countries and their associated telephone codes and international two-letter codes

States A list of states and provinces in the U.S. and Canada and their associated two-letter codes for addressing envelopes

Correspondence A table for tracking correspondence with all contacts

Assigning Primary Keys

For each of these tables, you need to define a primary key. The primary key for a table is a table field that can be used to uniquely identify any record in the table without reference to information in the table. This means that the primary key value needs to be unique for each record in the table.

In some cases, data being tracked in the table may be suited to being the primary key. For instance, an employee identification number will be unique for each employee and therefore can serve as the primary key. However, in many tables, a field will not be suited to being the primary key. In these cases, you need to create an additional field in the table for the purposes of storing an arbitrary primary key.

When using such an arbitrary primary key, different approaches can be taken in deciding what value to use for the key. The simplest approach is to use an automatically incrementing number for the primary key; that is, with each new record, the value of the primary key increments by one, and new records can never have a primary key smaller than any used before. Therefore, if a record in the middle of the table is deleted, its primary key is not freed up for reuse by a new record.

Other approaches include deriving the primary key from information in the table based on a formula that is guaranteed to provide a unique value. This approach has advantages in terms of being able to derive the key for any record and provides a non-arbitrary relationship between the key and the data in the record. For the purposes of small databases, if the data in a table doesn't offer a possible primary key, it is probably easiest to use an automatically-incrementing number for the primary key...

Read More Show Less

Table of Contents

Introduction
Ch. 1 Creating Your First ColdFusion Template 3
Ch. 2 Passing Data between ColdFusion Templates 15
Ch. 3 Getting Data from a Database 43
Ch. 4 Creating and Manipulating Variables 75
Ch. 5 Functions 91
Ch. 6 Writing Expressions 97
Ch. 7 Controlling the Flow of Your Templates 115
Ch. 8 Including Outside Code 129
Ch. 9 Creating Databases and Tables 143
Ch. 10 Using CFQUERY and SQL to Interact with the Database 159
Ch. 11 Using Advanced Query Techniques 221
Ch. 12 Grouping, Nesting, and Formatting Outputs 269
Ch. 13 Looping 295
Ch. 14 Working with ColdFusion Data Structures 307
Ch. 15 Forms 337
Ch. 16 Validating Form Data 419
Ch. 17 Implementing the ColdFusion Web Application Framework 443
Ch. 18 Implementing Error Control 507
Ch. 19 File Management 543
Ch. 20 ColdFusion Studio 559
Ch. 21 Sending Mail 595
Ch. 22 Reading Mail 613
Ch. 23 Using the HTTP Protocol 639
Ch. 24 Accessing FTP Servers 659
Ch. 25 Working with LDAP Servers 675
Ch. 26 Evaluating Dynamic Expressions 685
Ch. 27 ColdFusion Scripting 695
Ch. 28 Scheduling Events 705
Ch. 29 Implementing a Search Engine 721
Ch. 30 Application Security 739
Ch. 31 Building ColdFusion Custom Tags 763
Ch. 32 Including External Objects 795
Ch. 33 WDDX 805
Ch. 34 Using the CFREGISTRY Tag 827
Ch. 35 ColdFusion Administration 839
Ch. 36 ColdFusion for Linux 881
App. A Installing ColdFusion 889
App. B ColdFusion Tag Reference 897
App. C ColdFusion Function Reference 955
App. D Differences between ColdFusion and Traditional Server-Side Programming 1013
App. E SQL Functions and Data Types 1019
App. F: Additional Resources 1031
Index 1035
Read More Show Less

Customer Reviews

Average Rating 4
( 5 )
Rating Distribution

5 Star

(2)

4 Star

(2)

3 Star

(0)

2 Star

(1)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 5 Customer Reviews
  • Anonymous

    Posted July 8, 2001

    A good book for beginner and reference for the rest

    The fact that I use it as the textbook for my 600 over students means this book is good for beginners. It contains a lot of examples and explanation. Very good explanation on session management, etc. I prefer this book to Ben Forta's The ColdFusion 4.0 Web Application Construction Kit. However, if you want something very advanced, then go for Ben Forta's Advanced ColdFusion 4 Application Development (it's the Volume 2 of his ColdFusion book). In fact, I think it's more worthy to get 1 book of Mastering ColdFusion 4.5 than 2 volumes of Ben Forta's book.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 1, 2001

    OKAY but not the ticket

    I have just finished reading this book and found it very confusing! If you are new to coldfusion this book is okay, however if you already understand a little about cold fusion do not bother. This book was very poorly organized, leading you in developement of a data source you never use, giving examples of applications (one of the most important aspects of coldfusion) and never really follows through with explianations of why something was done. I found this book to only add to my frustration level! You can certainly tell that the writes know what they are talking about, however they can not transform their knowledge into a legiable format!

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 16, 2000

    Great book!

    I have been developing in Coldfusion for about six months and picked this book up mainly as a reference. I have never needed to look farther than this book for any questions or problems that I've had. I own two other Coldfusion books and have yet to put a crease in their covers. I'm amazed at the diversity of information contained here. It covers everything from the simplist of functions to the much more advanced.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted June 24, 2000

    Best Cold Fusion book ever

    I have been a programmer for 15 years and am extreamly impressed with this book. I highly recommend it for the novist and experiance programmer alike.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted June 23, 2000

    Excellent choice

    This book is an excellent resource for any ColdFusion developer. The presentation and subject matter are outstanding. A few sections on some of the more advanced topics are a little confusing to read, but overall this is a must-have book. I own Ben Forta's ColdFusion books and this book is an excellent cross-reference and filler for information missing from those books and for topics related to ColdFusion 4.5.1.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 5 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)