Errata
Cold Fusion Web Application Construction Kit · ISBN 078971809x · 142 corrections
Initial printing
| 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. |
| 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. |
| 149 | Section “WHERE Condition”, first words. | Should read “For the examples”. |
| 149 | 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”. |
| 157 | Figure 8.23. | Callout should be pointing to the middle row, not the bottom row. |
| 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. |
| 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. |
| 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.”. |
| 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.”. |
| 189 | Final paragraph, second line. | Should read “As such, it does much more than edit files” (not “then”). |
| 197 | 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>. |
| 210 | 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”. |
| 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”. |
| 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”. |
| 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”. |
| 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”. |
| 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”. |
| 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”. |
| 292 | Listing 13.13, seven lines from bottom of page. | NAME attribute should be “City”. |
| 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 | Listing 13.14 | Final link in listing (7 code lines from end of listing) should point to file “empau4.cfm”. |
| 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”. |
| 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”. |
| 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”. |
| 315 | Caution text. | Should read “Make sure you always specify a WHERE clause criterion”. |
| 317 | Table 15.2, description of _eurodate. | Should read “but with day before month”. |
| 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”. |
| 330 | First paragraph, second sentence (“This is why …”). | Entire sentence must be removed as Crystal Reports is no longer bundled with ColdFusion. |
| 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. |
| 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. |
| 338 | 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”. |
| 350 | 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”. |
| 373 | 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”. |
| 404 | 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”. |
| 440 | 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.6, first line. | First line (the <CFQUERY> tag) should not be there. |
| 482 | Listing 21.5, last line. | Last line (the <CFQUERY> tag) should not be there. |
| 489 | Listing 21.5. | The line immediately after the second </TR> is extraneous and should be deleted. |
| 490 | Listing 21.6, first line. | First line (the <CFQUERY> tag) should not be there. |
| 490 | Listing 21.5, last line. | Last 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. |
| 507 | 3rd line. | Should read “button is displayed if there are any previous records”. |
| 508 | Bullet beginning CACHEDWITH. | Should read CACHEDWITHIN. |
| 531 | First paragraph of section entitled “Using CFSELECT”, end of fifth line. | Should read “Both use the same query:”. |
| 531 | 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:”. |
| 539 | 5 lines from bottom of page, word “TED”. | Should read “SELECTED”. |
| 566 | Paragraph beginning “To get a book’s category”, last line, third word. | Should read “CategoryID”. |
| 574 | 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”. |
| 589 | 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#”. |
| 608 | Listing 25.1, “set defaults” section, fifth CFPARAM. | Should read DEFAULT=”icverify”. |
| 609 | Listing 25.2, code following the <CFFORM> tag. | The opening <CFINPUT> tag is missing the text “<CFINPUT”. |
| 610 | Listing 25.1, last line on page. | Should read email=”#form.email#”. |
| 613 | Listing 25.4. | Listing is of file QUICKSTORE_PRODUCT, not QUICKSTORE_CATEGORY as stated. |
| 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. |
| 627 | Listing 25.8, SQL in INSERT statement. | Remove all single quotes from around the column names in the INSERT statement. |
| 635 | 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.4, comment beginning with the text “Grab all of the values”. | Word “variables” is misspelled. |
| 661 | Listing 27.10, CFLOOP. | Extra set of double quotes around the string to be evaluated, should be a single set of double quotes. |
| 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. |
| 666 | Listing 28.1, last line. | Should read “ATTRIBUTE”. |
| 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”. |
| 674 | Listing 28.5. | Seventh line of code snippet has extraneous double quotes, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 674 | Listing 28.4. | Sixth line of code snippet has extraneous characters, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 674 | 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.5. | Seventh line of code snippet has extraneous double quotes, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 682 | Listing 28.4. | Sixth line of code snippet has extraneous characters, should be <BODY BGCOLOR=”#FFFFFF”>. |
| 682 | Listing 28.5, final six lines. | Should read: <BODY BGCOLOR=”#FFFFFF”> <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)#). |
| 734 | 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.”. |
| 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.”. |
| 785 | <CFASSOCIATE> tag, Table A.4, second row. | Attribute should be “DATACOLLECTION”. |
| 789 | First example of <CFCOOKIE> tag. | Example should read: <CFCOOKIE NAME=”USER_ID” VALUE=”100″ EXPIRES=”60″>. |
| 789 | Second <CFCOOKIE> example. | Should read: <CFCOOKIE NAME=”access” VALUE=”admin” SECURE>. |
| 793 | <CFASSOCIATE> tag, Table A.4, second row. | Attribute should be “DATACOLLECTION”. |
| 797 | First example of <CFCOOKIE> tag. | Example should read: <CFCOOKIE NAME=”USER_ID” VALUE=”100″ EXPIRES=”60″>. |
| 797 | Second <CFCOOKIE> example. | Should read: <CFCOOKIE NAME=”access” VALUE=”admin” SECURE>. |
| 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”>. |
| 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”>. |
| 826 | First line of syntax of <CFMAIL> tag. | Should read “<CFMAIL”. |
| 834 | 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. |
| 859 | <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()))#”. |
| 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()))#”. |
| 927 | Evaluate function, code example. | Should read: #Evaluate(“A”)#. |
| 927 | DE function, final line of description. | Should read “Evaluate”. |
| 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(). |
| 935 | Evaluate function, code example. | Should read: #Evaluate(“A”)#. |
| 935 | DE function, final line of description. | Should read “Evaluate”. |
| 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(). |