Errata for The ColdFusion 4.0 Web Application Construction Kit

As much as I’d like to be able to produce completely error free books, the reality of the computer publishing industry is that the pace at which books must be written and released makes this very difficult. And regretfully, my own books do have sporadic mistakes and typos scattered throughout them.

For the benefit of my readers, here is a current errata for The ColdFusion 4.0 Web Application Construction Kit. Feel free to print this page for future reference.

And as always, if you come across errors that I do not know about, please let me know. I’ll make sure they are added to this list, and will try to have them corrected in future reprints.

This title has been printed multiple times, and different errata are available for each. Select the print you have:


Original printing (with incorrect chapter 4), last numbered page is 1001. (1,006 pages, published December 23, 1998)

PageLocationCorrection
2Section entitled “How to Use This Book”, third paragraph.Word “developing” misspelled (and contains an extraneous character).
57Chapter 4, “Administering ColdFusion”.In the first printing this entire chapter is incorrect (it is the chapter from the previous book). This was corrected in the second printing. The correct chapter can be downloaded from the Macmillan Web site (http://www.mcp.com).
112Last paragraph on page.First 12 words (up to the word “all”) should not be there. Paragraph should begin “All text columns”.
116Figure 7.9.Table shown in figure is incorrect as the primary key has not been set.
149Figure 8.23.Callout should be pointing to the middle row, not the bottom row.
149Section “WHERE Condition”, first words.Should read “For the examples”.
158Figure 9.5 caption.Caption is incorrect, should read “Microsoft Query notifies you of your SQL statements’ success or failure”.
162Figure 9.9.Incorrect screen shot shown in figure, text in WHERE clause should be as shown in listing 9.4 above the figure.
180“Using Tag Insight” step 2.Should read “In the Editor window, type <BODY followed by a space and then wait a second or two.”.
189Final paragraph, second line.Should read “As such, it does much more than edit files” (not “then”).
202Paragraph beginning “The code between”.<CFOUPUT> on third line should be <CFOUTPUT>.
218Paragraph beginning “Next comes”.<CFOUTOUT> on first line should be <CFOUTPUT>.
221Paragraph after note, last line.Should read “would be fragmented”.
222Second paragraph, opening words.Should read “Listing 11.15 is the same template you created in Listing 11.3”.
232Listing 12.5, listing title.Title should read “Using a default radio button selection”.
234Figure 12.7.Incorrect figure shown, should be a listbox, not a textarea field.
236Figure 12.8.Incorrect figure shown, the correct figure is the one used for figure 12.7 on page 234.
237Final line of tip near top of page.Should read “in Appendix B, ColdFusion Function Reference”.
239Listing 12.11.Listing is “FORMS11.CFM”.
272Paragraph beginning “This SQL statement”.Sentence should read “This SQL statement updates the six specified columns for the employee whose ID is the passed EmployeeID”.
276Listing 13.11, last line in page.NAME attribute should be “City”.
284Listing 13.13, seven lines from bottom of page.NAME attribute should be “City”.
287Listing 13.14Final link in listing (7 code lines from end of listing) should point to file “empau4.cfm”.
294Bulleted list in section entitled “Navigating the SQL Query Builder”.Second item in bulleted list (beginning “right click in the editor window”) should be deleted.
295Paragraph beginning “The Query Builder window”.Word “toolbars” at end of first line should be “toolbar”.
301Paragraph beginning “To apply filtering”, first line.Should read “specify a search crierion in the Criteria”.
309Caution text.Should read “Make sure you always specify a WHERE clause criterion”.
313Paragraph beginning “Neither of these options is perfect”, last word of first line.Should be “complementing”.
317Table 15.2, description of _eurodate.Should read “but with day before month”.
330Note in the middle of the page.This note is now incorrect. ColdFusion no longer installs all the components needed to execute RPT files, and Crystal Reports must be installed on the server before ColdFusion’s Crystal Reports integration can be used.
330First paragraph, second sentence (“This is why …”).Entire sentence must be removed as Crystal Reports is no longer bundled with ColdFusion.
342Table 17,1 first row in Web Server column.Should read “Microsoft IIS and Personal Web Server”.
365Part IV chapter list, final two entries.Chapter 31 is “Version Control”, chapter 32 is “Event Scheduling”.
396Listing 19.13.Table is named “order” not “orders”.
432First paragraph, final words.Should read “the more of a difference the use of stored procedures makes”.
481Listing 21.5.The line immediately after the second </TR> is extraneous and should be deleted.
482Listing 21.5, last line.Last line (the <CFQUERY> tag) should not be there.
482Listing 21.6, first line.First line (the <CFQUERY> tag) should not be there.
4993rd line.Should read “button is displayed if there are any previous records”.
500Bullet beginning CACHEDWITH.Should read CACHEDWITHIN.
5315 lines from bottom of page, word “TED”.Should read “SELECTED”.
531First paragraph of section entitled “Using CFSELECT”, end of fifth line.Should read “Both use the same query:”.
566Paragraph beginning “To get a book’s category”, last line, third word.Should read “CategoryID”.
581Paragraph beginning “Your ColdFusion Web applications”, last line.Should read “many common Web applications”.
600Listing 25.1, “set defaults” section, fifth CFPARAM.Should read DEFAULT=”icverify”.
602Listing 25.1, last line on page.Should read email=”#form.email#”.
609Listing 25.2, code following the <CFFORM> tag.The opening <CFINPUT> tag is missing the text “<CFINPUT”.
613Listing 25.4.Listing is of file QUICKSTORE_PRODUCT, not QUICKSTORE_CATEGORY as stated.
627Listing 25.8, SQL in INSERT statement.Remove all single quotes from around the column names in the INSERT statement.
653Listing 27.4, comment beginning with the text “Grab all of the values”.Word “variables” is misspelled.
655Paragraph beginning “Notice also in”.Should refer to “Listing 27.5”.
657Listing 27.7, CFLOOP.Extra set of double quotes around the string to be evaluated, should be a single set of double quotes.
661Listing 27.10, CFLOOP.Extra set of double quotes around the string to be evaluated, should be a single set of double quotes.
666Listing 28.1, last line.Should read “ATTRIBUTE”.
674Listing 28.5, final six lines.Should read: <BODY BGCOLOR=”#FFFFFF”> <CFFILE DESTINATION=”H:\website\uploads” ACTION=”UPLOAD” NAMECONFLICT=”#FORM.FILEACTION#” FILEFIELD=”FileName”>
674Listing 28.4.Sixth line of code snippet has extraneous characters, should be <BODY BGCOLOR=”#FFFFFF”>.
674Listing 28.5.Seventh line of code snippet has extraneous double quotes, should be <BODY BGCOLOR=”#FFFFFF”>.
674Listing 28.5.The <CFFILE> tag at the bottom of the page contains extraneous characters. The correct code should read <CFFILE DESTINATION=”H:\website\uploads” ACTION=”UPLOAD” NAMECONFLICT=”#FORM.FILEACTION#” FILEFIELD=”FileName”>.
726Listing 29.15, 8th line.Should read: WHERE BookID IN (#QuotedValueList(VeritySearch.KEY)#).
773Table 32.1, description of INTERVAL attribute.Should read “Required when creating tasks with ACTION=”UPDATE”. Interval at which task should be scheduled. Can be set to minutes or as DAILY, WEEKLY and MONTHLY. The default interval is one hour, and the minimum interval is one minute.”.
785<CFASSOCIATE> tag, Table A.4, second row.Attribute should be “DATACOLLECTION”.
789Second <CFCOOKIE> example.Should read: <CFCOOKIE NAME=”access” VALUE=”admin” SECURE>.
789First example of <CFCOOKIE> tag.Example should read: <CFCOOKIE NAME=”USER_ID” VALUE=”100″ EXPIRES=”60″>.
812Table A.33.Fields should be #CFHTTP.FileContent# and #CFHTTP.MimeType#.
814<CFINCLUDE> example.<CFINCLUDE> requires complete file paths, the second line of code should read: <CFINCLUDE TEMPLATE=”#GetDirectoryFromPath(GetCurrentTemplatePath())#/footer.cfm”>.
826First line of syntax of <CFMAIL> tag.Should read “<CFMAIL”.
851<CFSWITCH> code example.Correct tags are <CFDEFAULTCASE> and </CFDEFAULTCASE>, not <CFCASEDEFAULT> and </CFCASEDEFAULT> as shown.
882DateAdd() function, text before second example listing, words “10 years earlier”.Should read “10 weeks earlier”.
888Code example for MonthAsString() function.Correct example should read “It is #MonthAsString(Month(Now()))#”.
927DE function, final line of description.Should read “Evaluate”.
927Evaluate function, code example.Should read: #Evaluate(“A”)#.
932“QuotedValueList(), ValueList()” example.Shoud read: “The following example passes the results from one query to a second query: SELECT * FROM Customers WHERE CustomerType IN (#QuotedList(CustType.type)#)”.
933URLEncodedValue function.The definition and example are incorrect, the correct function name is URLEncodedFormat().

First reprint (with corrected chapter 4), last numbered page is 1000. (1,006 pages, published January 1, 1999)

PageLocationCorrection
2Section entitled “How to Use This Book”, third paragraph.Word “developing” misspelled (and contains an extraneous character).
120Last paragraph on page.First 12 words (up to the word “all”) should not be there. Paragraph should begin “All text columns”.
124Figure 7.9.Table shown in figure is incorrect as the primary key has not been set.
157Figure 8.23.Callout should be pointing to the middle row, not the bottom row.
157Section “WHERE Condition”, first words.Should read “For the examples”.
166Figure 9.5 caption.Caption is incorrect, should read “Microsoft Query notifies you of your SQL statements’ success or failure”.
170Figure 9.9.Incorrect screen shot shown in figure, text in WHERE clause should be as shown in listing 9.4 above the figure.
188“Using Tag Insight” step 2.Should read “In the Editor window, type <BODY followed by a space and then wait a second or two.”.
197Final paragraph, second line.Should read “As such, it does much more than edit files” (not “then”).
210Paragraph beginning “The code between”.<CFOUPUT> on third line should be <CFOUTPUT>.
226Paragraph beginning “Next comes”.<CFOUTOUT> on first line should be <CFOUTPUT>.
229Paragraph after note, last line.Should read “would be fragmented”.
230Second paragraph, opening words.Should read “Listing 11.15 is the same template you created in Listing 11.3”.
240Listing 12.5, listing title.Title should read “Using a default radio button selection”.
242Figure 12.7.Incorrect figure shown, should be a listbox, not a textarea field.
244Figure 12.8.Incorrect figure shown, the correct figure is the one used for figure 12.7 on page 242.
245Final line of tip near top of page.Should read “in Appendix B, ColdFusion Function Reference”.
247Listing 12.11.Listing is “FORMS11.CFM”.
280Paragraph beginning “This SQL statement”.Sentence should read “This SQL statement updates the six specified columns for the employee whose ID is the passed EmployeeID”.
284Listing 13.11, last line in page.NAME attribute should be “City”.
292Listing 13.13, seven lines from bottom of page.NAME attribute should be “City”.
295Listing 13.14Final link in listing (7 code lines from end of listing) should point to file “empau4.cfm”.
302Bulleted list in section entitled “Navigating the SQL Query Builder”.Second item in bulleted list (beginning “right click in the editor window”) should be deleted.
303Paragraph beginning “The Query Builder window”.Word “toolbars” at end of first line should be “toolbar”.
309Paragraph beginning “To apply filtering”, first line.Should read “specify a search crierion in the Criteria”.
315Caution text.Should read “Make sure you always specify a WHERE clause criterion”.
321Paragraph beginning “Neither of these options is perfect”, last word of first line.Should be “complementing”.
325Table 15.2, description of _eurodate.Should read “but with day before month”.
338First paragraph, second sentence (“This is why …”).Entire sentence must be removed as Crystal Reports is no longer bundled with ColdFusion.
338Note in the middle of the page.This note is now incorrect. ColdFusion no longer installs all the components needed to execute RPT files, and Crystal Reports must be installed on the server before ColdFusion’s Crystal Reports integration can be used.
350Table 17,1 first row in Web Server column.Should read “Microsoft IIS and Personal Web Server”.
373Part IV chapter list, final two entries.Chapter 31 is “Version Control”, chapter 32 is “Event Scheduling”.
404Listing 19.13.Table is named “order” not “orders”.
440First paragraph, final words.Should read “the more of a difference the use of stored procedures makes”.
489Listing 21.5.The line immediately after the second </TR> is extraneous and should be deleted.
490Listing 21.5, last line.Last line (the <CFQUERY> tag) should not be there.
490Listing 21.6, first line.First line (the <CFQUERY> tag) should not be there.
5073rd line.Should read “button is displayed if there are any previous records”.
508Bullet beginning CACHEDWITH.Should read CACHEDWITHIN.
5395 lines from bottom of page, word “TED”.Should read “SELECTED”.
539First paragraph of section entitled “Using CFSELECT”, end of fifth line.Should read “Both use the same query:”.
574Paragraph beginning “To get a book’s category”, last line, third word.Should read “CategoryID”.
589Paragraph beginning “Your ColdFusion Web applications”, last line.Should read “many common Web applications”.
608Listing 25.1, “set defaults” section, fifth CFPARAM.Should read DEFAULT=”icverify”.
610Listing 25.1, last line on page.Should read email=”#form.email#”.
617Listing 25.2, code following the <CFFORM> tag.The opening <CFINPUT> tag is missing the text “<CFINPUT”.
621Listing 25.4.Listing is of file QUICKSTORE_PRODUCT, not QUICKSTORE_CATEGORY as stated.
635Listing 25.8, SQL in INSERT statement.Remove all single quotes from around the column names in the INSERT statement.
661Listing 27.4, comment beginning with the text “Grab all of the values”.Word “variables” is misspelled.
663Paragraph beginning “Notice also in”.Should refer to “Listing 27.5”.
665Listing 27.7, CFLOOP.Extra set of double quotes around the string to be evaluated, should be a single set of double quotes.
669Listing 27.10, CFLOOP.Extra set of double quotes around the string to be evaluated, should be a single set of double quotes.
674Listing 28.1, last line.Should read “ATTRIBUTE”.
682Listing 28.5, final six lines.Should read: <BODY BGCOLOR=”#FFFFFF”> <CFFILE DESTINATION=”H:\website\uploads” ACTION=”UPLOAD” NAMECONFLICT=”#FORM.FILEACTION#” FILEFIELD=”FileName”>
682Listing 28.4.Sixth line of code snippet has extraneous characters, should be <BODY BGCOLOR=”#FFFFFF”>.
682Listing 28.5.Seventh line of code snippet has extraneous double quotes, should be <BODY BGCOLOR=”#FFFFFF”>.
682Listing 28.5.The <CFFILE> tag at the bottom of the page contains extraneous characters. The correct code should read <CFFILE DESTINATION=”H:\website\uploads” ACTION=”UPLOAD” NAMECONFLICT=”#FORM.FILEACTION#” FILEFIELD=”FileName”>.
734Listing 29.15, 8th line.Should read: WHERE BookID IN (#QuotedValueList(VeritySearch.KEY)#).
781Table 32.1, description of INTERVAL attribute.Should read “Required when creating tasks with ACTION=”UPDATE”. Interval at which task should be scheduled. Can be set to minutes or as DAILY, WEEKLY and MONTHLY. The default interval is one hour, and the minimum interval is one minute.”.
793<CFASSOCIATE> tag, Table A.4, second row.Attribute should be “DATACOLLECTION”.
797Second <CFCOOKIE> example.Should read: <CFCOOKIE NAME=”access” VALUE=”admin” SECURE>.
797First example of <CFCOOKIE> tag.Example should read: <CFCOOKIE NAME=”USER_ID” VALUE=”100″ EXPIRES=”60″>.
820Table A.33.Fields should be #CFHTTP.FileContent# and #CFHTTP.MimeType#.
822<CFINCLUDE> example.<CFINCLUDE> requires complete file paths, the second line of code should read: <CFINCLUDE TEMPLATE=”#GetDirectoryFromPath(GetCurrentTemplatePath())#/footer.cfm”>.
834First line of syntax of <CFMAIL> tag.Should read “<CFMAIL”.
859<CFSWITCH> code example.Correct tags are <CFDEFAULTCASE> and </CFDEFAULTCASE>, not <CFCASEDEFAULT> and </CFCASEDEFAULT> as shown.
890DateAdd() function, text before second example listing, words “10 years earlier”.Should read “10 weeks earlier”.
896Code example for MonthAsString() function.Correct example should read “It is #MonthAsString(Month(Now()))#”.
935DE function, final line of description.Should read “Evaluate”.
935Evaluate function, code example.Should read: #Evaluate(“A”)#.
940“QuotedValueList(), ValueList()” example.Shoud read: “The following example passes the results from one query to a second query: SELECT * FROM Customers WHERE CustomerType IN (#QuotedList(CustType.type)#)”.
941URLEncodedValue function.The definition and example are incorrect, the correct function name is URLEncodedFormat().