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)
- First reprint (with corrected chapter 4), last numbered page is 1000. (1,006 pages, published January 1, 1999)
Original printing (with incorrect chapter 4), last numbered page is 1001. (1,006 pages, published December 23, 1998)
| Page | Location | Correction |
|---|---|---|
| 2 | Section entitled “How to Use This Book”, third paragraph. | Word “developing” misspelled (and contains an extraneous character). |
| 57 | Chapter 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). |
| 112 | Last paragraph on page. | First 12 words (up to the word “all”) should not be there. Paragraph should begin “All text columns”. |
| 116 | Figure 7.9. | Table shown in figure is incorrect as the primary key has not been set. |
| 149 | Figure 8.23. | Callout should be pointing to the middle row, not the bottom row. |
| 149 | Section “WHERE Condition”, first words. | Should read “For the examples”. |
| 158 | Figure 9.5 caption. | Caption is incorrect, should read “Microsoft Query notifies you of your SQL statements’ success or failure”. |
| 162 | Figure 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.”. |
| 189 | Final paragraph, second line. | Should read “As such, it does much more than edit files” (not “then”). |
| 202 | Paragraph beginning “The code between”. | <CFOUPUT> on third line should be <CFOUTPUT>. |
| 218 | Paragraph beginning “Next comes”. | <CFOUTOUT> on first line should be <CFOUTPUT>. |
| 221 | Paragraph after note, last line. | Should read “would be fragmented”. |
| 222 | Second paragraph, opening words. | Should read “Listing 11.15 is the same template you created in Listing 11.3”. |
| 232 | Listing 12.5, listing title. | Title should read “Using a default radio button selection”. |
| 234 | Figure 12.7. | Incorrect figure shown, should be a listbox, not a textarea field. |
| 236 | Figure 12.8. | Incorrect figure shown, the correct figure is the one used for figure 12.7 on page 234. |
| 237 | Final line of tip near top of page. | Should read “in Appendix B, ColdFusion Function Reference”. |
| 239 | Listing 12.11. | Listing is “FORMS11.CFM”. |
| 272 | Paragraph beginning “This SQL statement”. | Sentence should read “This SQL statement updates the six specified columns for the employee whose ID is the passed EmployeeID”. |
| 276 | Listing 13.11, last line in page. | NAME attribute should be “City”. |
| 284 | Listing 13.13, seven lines from bottom of page. | NAME attribute should be “City”. |
| 287 | Listing 13.14 | Final link in listing (7 code lines from end of listing) should point to file “empau4.cfm”. |
| 294 | Bulleted list in section entitled “Navigating the SQL Query Builder”. | Second item in bulleted list (beginning “right click in the editor window”) should be deleted. |
| 295 | Paragraph beginning “The Query Builder window”. | Word “toolbars” at end of first line should be “toolbar”. |
| 301 | Paragraph beginning “To apply filtering”, first line. | Should read “specify a search crierion in the Criteria”. |
| 309 | Caution text. | Should read “Make sure you always specify a WHERE clause criterion”. |
| 313 | Paragraph beginning “Neither of these options is perfect”, last word of first line. | Should be “complementing”. |
| 317 | Table 15.2, description of _eurodate. | Should read “but with day before month”. |
| 330 | Note 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. |
| 330 | First paragraph, second sentence (“This is why …”). | Entire sentence must be removed as Crystal Reports is no longer bundled with ColdFusion. |
| 342 | Table 17,1 first row in Web Server column. | Should read “Microsoft IIS and Personal Web Server”. |
| 365 | Part IV chapter list, final two entries. | Chapter 31 is “Version Control”, chapter 32 is “Event Scheduling”. |
| 396 | Listing 19.13. | Table is named “order” not “orders”. |
| 432 | First paragraph, final words. | Should read “the more of a difference the use of stored procedures makes”. |
| 481 | Listing 21.5. | The line immediately after the second </TR> is extraneous and should be deleted. |
| 482 | Listing 21.5, last line. | Last line (the <CFQUERY> tag) should not be there. |
| 482 | Listing 21.6, first line. | First line (the <CFQUERY> tag) should not be there. |
| 499 | 3rd line. | Should read “button is displayed if there are any previous records”. |
| 500 | Bullet beginning CACHEDWITH. | Should read CACHEDWITHIN. |
| 531 | 5 lines from bottom of page, word “TED”. | Should read “SELECTED”. |
| 531 | First paragraph of section entitled “Using CFSELECT”, end of fifth line. | Should read “Both use the same query:”. |
| 566 | Paragraph beginning “To get a book’s category”, last line, third word. | Should read “CategoryID”. |
| 581 | Paragraph beginning “Your ColdFusion Web applications”, last line. | Should read “many common Web applications”. |
| 600 | Listing 25.1, “set defaults” section, fifth CFPARAM. | Should read DEFAULT=”icverify”. |
| 602 | Listing 25.1, last line on page. | Should read email=”#form.email#”. |
| 609 | Listing 25.2, code following the <CFFORM> tag. | The opening <CFINPUT> tag is missing the text “<CFINPUT”. |
| 613 | Listing 25.4. | Listing is of file QUICKSTORE_PRODUCT, not QUICKSTORE_CATEGORY as stated. |
| 627 | Listing 25.8, SQL in INSERT statement. | Remove all single quotes from around the column names in the INSERT statement. |
| 653 | Listing 27.4, comment beginning with the text “Grab all of the values”. | Word “variables” is misspelled. |
| 655 | Paragraph beginning “Notice also in”. | Should refer to “Listing 27.5”. |
| 657 | Listing 27.7, CFLOOP. | Extra set of double quotes around the string to be evaluated, should be a single set of double quotes. |
| 661 | Listing 27.10, CFLOOP. | Extra set of double quotes around the string to be evaluated, should be a single set of double quotes. |
| 666 | Listing 28.1, last line. | Should read “ATTRIBUTE”. |
| 674 | Listing 28.5, final six lines. | Should read: <BODY BGCOLOR=”#FFFFFF”> <CFFILE DESTINATION=”H:\website\uploads” ACTION=”UPLOAD” NAMECONFLICT=”#FORM.FILEACTION#” FILEFIELD=”FileName”> |
| 674 | Listing 28.4. | Sixth line of code snippet has extraneous characters, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 674 | Listing 28.5. | Seventh line of code snippet has extraneous double quotes, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 674 | Listing 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”>. |
| 726 | Listing 29.15, 8th line. | Should read: WHERE BookID IN (#QuotedValueList(VeritySearch.KEY)#). |
| 773 | Table 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”. |
| 789 | Second <CFCOOKIE> example. | Should read: <CFCOOKIE NAME=”access” VALUE=”admin” SECURE>. |
| 789 | First example of <CFCOOKIE> tag. | Example should read: <CFCOOKIE NAME=”USER_ID” VALUE=”100″ EXPIRES=”60″>. |
| 812 | Table 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”>. |
| 826 | First 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. |
| 882 | DateAdd() function, text before second example listing, words “10 years earlier”. | Should read “10 weeks earlier”. |
| 888 | Code example for MonthAsString() function. | Correct example should read “It is #MonthAsString(Month(Now()))#”. |
| 927 | DE function, final line of description. | Should read “Evaluate”. |
| 927 | Evaluate 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)#)”. |
| 933 | URLEncodedValue 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)
| Page | Location | Correction |
|---|---|---|
| 2 | Section entitled “How to Use This Book”, third paragraph. | Word “developing” misspelled (and contains an extraneous character). |
| 120 | Last paragraph on page. | First 12 words (up to the word “all”) should not be there. Paragraph should begin “All text columns”. |
| 124 | Figure 7.9. | Table shown in figure is incorrect as the primary key has not been set. |
| 157 | Figure 8.23. | Callout should be pointing to the middle row, not the bottom row. |
| 157 | Section “WHERE Condition”, first words. | Should read “For the examples”. |
| 166 | Figure 9.5 caption. | Caption is incorrect, should read “Microsoft Query notifies you of your SQL statements’ success or failure”. |
| 170 | Figure 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.”. |
| 197 | Final paragraph, second line. | Should read “As such, it does much more than edit files” (not “then”). |
| 210 | Paragraph beginning “The code between”. | <CFOUPUT> on third line should be <CFOUTPUT>. |
| 226 | Paragraph beginning “Next comes”. | <CFOUTOUT> on first line should be <CFOUTPUT>. |
| 229 | Paragraph after note, last line. | Should read “would be fragmented”. |
| 230 | Second paragraph, opening words. | Should read “Listing 11.15 is the same template you created in Listing 11.3”. |
| 240 | Listing 12.5, listing title. | Title should read “Using a default radio button selection”. |
| 242 | Figure 12.7. | Incorrect figure shown, should be a listbox, not a textarea field. |
| 244 | Figure 12.8. | Incorrect figure shown, the correct figure is the one used for figure 12.7 on page 242. |
| 245 | Final line of tip near top of page. | Should read “in Appendix B, ColdFusion Function Reference”. |
| 247 | Listing 12.11. | Listing is “FORMS11.CFM”. |
| 280 | Paragraph beginning “This SQL statement”. | Sentence should read “This SQL statement updates the six specified columns for the employee whose ID is the passed EmployeeID”. |
| 284 | Listing 13.11, last line in page. | NAME attribute should be “City”. |
| 292 | Listing 13.13, seven lines from bottom of page. | NAME attribute should be “City”. |
| 295 | Listing 13.14 | Final link in listing (7 code lines from end of listing) should point to file “empau4.cfm”. |
| 302 | Bulleted list in section entitled “Navigating the SQL Query Builder”. | Second item in bulleted list (beginning “right click in the editor window”) should be deleted. |
| 303 | Paragraph beginning “The Query Builder window”. | Word “toolbars” at end of first line should be “toolbar”. |
| 309 | Paragraph beginning “To apply filtering”, first line. | Should read “specify a search crierion in the Criteria”. |
| 315 | Caution text. | Should read “Make sure you always specify a WHERE clause criterion”. |
| 321 | Paragraph beginning “Neither of these options is perfect”, last word of first line. | Should be “complementing”. |
| 325 | Table 15.2, description of _eurodate. | Should read “but with day before month”. |
| 338 | First paragraph, second sentence (“This is why …”). | Entire sentence must be removed as Crystal Reports is no longer bundled with ColdFusion. |
| 338 | Note 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. |
| 350 | Table 17,1 first row in Web Server column. | Should read “Microsoft IIS and Personal Web Server”. |
| 373 | Part IV chapter list, final two entries. | Chapter 31 is “Version Control”, chapter 32 is “Event Scheduling”. |
| 404 | Listing 19.13. | Table is named “order” not “orders”. |
| 440 | First paragraph, final words. | Should read “the more of a difference the use of stored procedures makes”. |
| 489 | Listing 21.5. | The line immediately after the second </TR> is extraneous and should be deleted. |
| 490 | Listing 21.5, last line. | Last line (the <CFQUERY> tag) should not be there. |
| 490 | Listing 21.6, first line. | First line (the <CFQUERY> tag) should not be there. |
| 507 | 3rd line. | Should read “button is displayed if there are any previous records”. |
| 508 | Bullet beginning CACHEDWITH. | Should read CACHEDWITHIN. |
| 539 | 5 lines from bottom of page, word “TED”. | Should read “SELECTED”. |
| 539 | First paragraph of section entitled “Using CFSELECT”, end of fifth line. | Should read “Both use the same query:”. |
| 574 | Paragraph beginning “To get a book’s category”, last line, third word. | Should read “CategoryID”. |
| 589 | Paragraph beginning “Your ColdFusion Web applications”, last line. | Should read “many common Web applications”. |
| 608 | Listing 25.1, “set defaults” section, fifth CFPARAM. | Should read DEFAULT=”icverify”. |
| 610 | Listing 25.1, last line on page. | Should read email=”#form.email#”. |
| 617 | Listing 25.2, code following the <CFFORM> tag. | The opening <CFINPUT> tag is missing the text “<CFINPUT”. |
| 621 | Listing 25.4. | Listing is of file QUICKSTORE_PRODUCT, not QUICKSTORE_CATEGORY as stated. |
| 635 | Listing 25.8, SQL in INSERT statement. | Remove all single quotes from around the column names in the INSERT statement. |
| 661 | Listing 27.4, comment beginning with the text “Grab all of the values”. | Word “variables” is misspelled. |
| 663 | Paragraph beginning “Notice also in”. | Should refer to “Listing 27.5”. |
| 665 | Listing 27.7, CFLOOP. | Extra set of double quotes around the string to be evaluated, should be a single set of double quotes. |
| 669 | Listing 27.10, CFLOOP. | Extra set of double quotes around the string to be evaluated, should be a single set of double quotes. |
| 674 | Listing 28.1, last line. | Should read “ATTRIBUTE”. |
| 682 | Listing 28.5, final six lines. | Should read: <BODY BGCOLOR=”#FFFFFF”> <CFFILE DESTINATION=”H:\website\uploads” ACTION=”UPLOAD” NAMECONFLICT=”#FORM.FILEACTION#” FILEFIELD=”FileName”> |
| 682 | Listing 28.4. | Sixth line of code snippet has extraneous characters, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 682 | Listing 28.5. | Seventh line of code snippet has extraneous double quotes, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 682 | Listing 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#” FILEFIEL D=”FileName”>. |
| 734 | Listing 29.15, 8th line. | Should read: WHERE BookID IN (#QuotedValueList(VeritySearch.KEY)#). |
| 781 | Table 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”. |
| 797 | Second <CFCOOKIE> example. | Should read: <CFCOOKIE NAME=”access” VALUE=”admin” SECURE>. |
| 797 | First example of <CFCOOKIE> tag. | Example should read: <CFCOOKIE NAME=”USER_ID” VALUE=”100″ EXPIRES=”60″>. |
| 820 | Table 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”>. |
| 834 | First 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. |
| 890 | DateAdd() function, text before second example listing, words “10 years earlier”. | Should read “10 weeks earlier”. |
| 896 | Code example for MonthAsString() function. | Correct example should read “It is #MonthAsString(Month(Now()))#”. |
| 935 | DE function, final line of description. | Should read “Evaluate”. |
| 935 | Evaluate 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)#)”. |
| 941 | URLEncodedValue function. | The definition and example are incorrect, the correct function name is URLEncodedFormat(). |