DOCUMENT:Q268120 21-APR-2001 [mspress] TITLE :Web Applications with Visual InterDev 6.0 Comments and Correctio PRODUCT :Microsoft Press PROD/VER:: OPER/SYS: KEYWORDS:kbdocfix kbdocerr ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - MSPRESS Web Applications with Microsoft Visual InterDev 6.0, MCSD Training Kit ISBN 0-7356-0967-5 ------------------------------------------------------------------------------- SUMMARY ======= This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Web Applications with Microsoft Visual InterDev 6.0, MCSD Training Kit, ISBN 0-7356-0967-5. The following topics are covered: - Page 76: Step 2, Image Has Not Been Placed In Sidebar.htm - Pages 80 & 451: Correction To Question 2 - Page 93: Incorrect Description Of cancelBubble Property - Page 150: ASP Buffering Is Disabled By Default - Page 172: Step 6 Is Incorrect - Page 175: In Code, Change "outdate" To "indate" - Page 177: In Code, Add Space Between "option" And "value" - Page 224: In Step 7 Click Next Not Save - Page 225: In Step 20 Click Open Not OK - Page 248: Change rsStudents.Open to rsEmployees.Open - Page 274-275: CDate Function Code Correction - Page 278: Code Correction - Page 467-468: Products.htm File Is Not Included On The CD-ROM - Lab 6, 7, 8 & 10: CDate Function Code Correction MORE INFORMATION ================ Page 76: Step 2, Image Has Not Been Placed In Sidebar.htm --------------------------------------------------------- On page 76, in Step 2 of Exercise 2, the instruction asks you to place the insertion point below the Chateau St. Mark image at the top of the page. There is no image in the sidebar.htm file. You will need to insert the chateauLogo.gif image at the top of the page before proceeding. To place the chateauLogo.gif image at the top of the page: 1. Place the insertion point at the top of the page. 2. On the HTML menu, click Image. The Insert Image dialog box appears. 3. For the picture source, enter or browse to the images/chateauLogo.gif file. 4. Click OK to insert the image. You can then proceed with the remainder of the exercise as outlined in the book. Pages 80 & 451: Correction To Question 2 ---------------------------------------- Question 2 on pages 80 and 451 is incorrect. Change: "List the Visual InterDev version-control tools" To: "List the Visual InterDev Toolbox tools" Page 93: Incorrect Description Of cancelBubble Property ------------------------------------------------------- The description of the cancelBubble property on page 93 is incorrect. By setting the cancelBubble to True, you prevent the parent element from receiving the event. The note on page 96 contains the correct description. Change: "By setting cancelBubble to False, you prevent the parent element from receiving the event. " To: "By setting cancelBubble to True, you prevent the parent element from receiving the event." Page 150: ASP Buffering Is Disabled By Default ---------------------------------------------- On page 150, the first sentence in the second paragraph incorrectly states that buffering is enabled by default for ASP applications. Change: "Although buffering is enabled by default for ASP applications, you can use the IIS snap-in to disable buffering for an entire ASP application." To: "Although buffering is disabled by default for ASP applications, you can use the IIS snap-in to enable buffering for an entire ASP application." Page 172: Step 6 Is Incorrect ----------------------------- On page 172, Step 6 indicates that you will be able to open the Reservation Form. However, you will not activate a link to this form until page 175, Step 5. Step 6 on page 172 should be omitted. Additional Note: the menus are on the left, not the right. Page 175: In Code, Change "outdate" To "indate" ----------------------------------------------- On page 175, in the code sample at the top of the page, change "outdate" to "indate" in the fifth line. Change: Request.Form("outdate") To: Request.Form("indate") Page 177: In Code, Add Space Between "option" And "value" --------------------------------------------------------- On page 177, in the sixth line of the code at the top of the page, there should be a space between "option" and "value". Change: optionvalue=" To: option value=" Page 224: In Step 7 Click Next Not Save --------------------------------------- On page 224, in step 7, you will need to click Next to continue. Change: "Type Data as the name of the DSN, and then click Save." To: "Type Data as the name of the DSN, and then click Next." Page 225: In Step 20 Click Open Not OK -------------------------------------- On page 225, in step 20, you will need to click Open to continue to the next step. Change: "Choose the Existing tab and browse for the Chateau.sql file in the Labs\Lab05\Partial folder, and then click OK." To: "Choose the Existing tab and browse for the Chateau.sql file in the Labs\Lab05\Partial folder, and then click Open." Page 248: Change rsStudents.Open to rsEmployees.Open ---------------------------------------------------- On page 248, in the sample code under "Using an Explicit Connection Object", rsStudents.Open should be rsEmployees.Open. Change: rsStudents.Open "Select * from Employees", cnData To: rsEmployees.Open "Select * from Employees", cnData Page 274-275: CDate Function Code Correction -------------------------------------------- To avoid errors in Lab 6, add single quotes around the CDate function as shown below: On page 274, change: SQL = "Insert Into Guests(FirstName, LastName, SmokingPref, " & _ "CreditType, CardNumber, ExpDate)" & _ "Values('" & Trim(Request.Form("FirstName")) & "', '" & _ Trim(Request.Form("LastName")) & "', " & SmokingPref & _ ", " & CInt(CreditType) & ", '" & Trim(Request.Form("CardNumber")) & _ "', " & CDate(Request.Form("ExpDate")) & ")" To: SQL = "Insert Into Guests(FirstName, LastName, SmokingPref, " & _ "CreditType, CardNumber, ExpDate)" & _ "Values('" & Trim(Request.Form("FirstName")) & "', '" & _ Trim(Request.Form("LastName")) & "', " & SmokingPref & _ ", " & CInt(CreditType) & ", '" & Trim(Request.Form("CardNumber")) & _ "', '" & CDate(Request.Form("ExpDate")) & "')" On page 275, change: SQL = "Update Guests Set FirstName = '" & _ Trim(Request.Form("FirstName")) & _ "', " & "SmokingPref = " & SmokingPref & ", " & _ "ExpDate = " & CDate(Request.Form("ExpDate")) & _ " Where GuestID = " & GuestID To: SQL = "Update Guests Set FirstName = '" & _ Trim(Request.Form("FirstName")) & _ "', " & "SmokingPref = " & SmokingPref & ", " & _ "ExpDate = '" & CDate(Request.Form("ExpDate")) & "' " & _ "Where GuestID = " & GuestID Page 278: Code Correction ------------------------- On page 278, in step 8, change the first line of code as follows. Change: If cdGuests.Recordset.EOF And cdGuests.Recordset.EOF Then To: If cdGuests.Recordset.BOF And cdGuests.Recordset.EOF Then Page 467-468: Products.htm File Is Not Included On The CD-ROM ------------------------------------------------------------- Pages 467 and 468 in Appendix B mention the Products.htm files provided on the companion CD. These sample files were not included on the CD-ROM. However, Microsoft Press has created AppendB.exe, a self-extracting executable file that contains the missing files. The following file is available for download from the Microsoft Download Center: AppendB.exe (http://download.microsoft.com/download/vinterdev60pro/mspress/1.0/WIN98Me/EN-US/AppendB.exe) For additional information about how to download Microsoft Support files, click the article number below to view the article in the Microsoft Knowledge Base: Q119591 How to Obtain Microsoft Support Files from Online Services Microsoft used the most current virus detection software available on the date of posting to scan this file for viruses. Once posted, the file is housed on secure servers that prevent any unauthorized changes to the file. More Information ---------------- On page 467, change the last sentence in the first paragraph under the section titled "Implementing the VBScript Language", From: "Use the page provided in the Practice\AppendB directory located on your hard drive or on the companion CD." To: "Use the page provided in the AppendB directory located on your hard drive or on the companion CD." On page 468, change Step 4 From: "In the Open File dialog, click the Existing tab, browse to the Practice\Ch03 folder, and select the Products.htm file." To: "In the Open File dialog, click the Existing tab, browse to the WebAppsMCSD\AppendB folder, and select the Products.htm file." Lab 6, 7, 8 & 10: CDate Function Code Correction ------------------------------------------------ To avoid errors in Lab 6, 7, 8 and 10, add single quotes around the CDate function in the following files: .\labs\lab06\solution\checkin.asp .\labs\lab07\partial\checkin.asp .\labs\lab07\solution\checkin.asp .\labs\lab08\partial\checkin.asp .\labs\lab08\solution\checkin.asp .\labs\lab10\partial\checkin.asp .\labs\solution\chateau_local\checkin.asp Change: "', " & CDate(Request.Form("ExpDate")) & ")" To: "', '" & CDate(Request.Form("ExpDate")) & "')" Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections. Additional query words: TKBOOK DEVBOOK VSTUDIO INTERDEV 0-7356-0967-5 ====================================================================== Keywords : kbdocfix kbdocerr Technology : kbMSPressSearch Version : : Issue type : kbinfo ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.