DOCUMENT:Q318910 02-JUL-2002 [mspress] TITLE :XML Programming Core Reference Comments and Corrections PRODUCT :Microsoft Press PROD/VER:: OPER/SYS: KEYWORDS:kbdocfix kbdocerr ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - MSPRESS XML Programming Core Reference ISBN 0-7356-1185-8 ------------------------------------------------------------------------------- SUMMARY ======= This article contains comments, corrections, and information about known errors relating to the Microsoft Press book XML Programming Core Reference, ISBN 0-7356-1185-8. The following topics are covered: - CD-ROM: Ch04 Code Sample openxml.sql Change - Page 7: "XTML" Should Be "XHTML" - Page 97: Missing Column Name In SELECT Statement - Page 98: Incorrect Dept_ID In Table - Page 130: Replace Code in Listing 4-27 - Page 140: Line Missing From Results of Listing 4-32 - Page 196: Document Element Incorrectly Repeated In Listing 5-10 - Page 343: Definition For Address-Object Missing MORE INFORMATION ================ CD-ROM: Ch04 Code Sample openxml.sql Change ------------------------------------------- The final line of code in the code sample openxml.sql, found in the ch04 directory, is incorrect. A replacement file is available for download. In the attached file, EXEC sp_xml_removeDocument @hXmlDoc has been changed to: EXEC sp_xml_removeDocument @xmlHnd The following file is available for download from the Microsoft Download Center: openxml.exe (http://download.microsoft.com/download /MSPressPub/openxml/1.0/WIN98XP/EN-US/openxml.exe) For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Q119591 How to Obtain Microsoft Support Files from Online Services Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on secure servers that prevent any unauthorized changes to the file. Page 7: "XTML" Should Be "XHTML" -------------------------------- On page 7, change the section heading: "XML Compared to XTML" To: "XML Compared to XHTML" Page 97: Missing Column Name In SELECT Statement ------------------------------------------------ On page 97, in the first code sample, the column name Employee_ID is missing. Change: SELECT CONCATENATE( LastName, ' ', FirstName ) AS Fullname FROM Employee WHERE LastName = 'Jordan' To: SELECT Employee_ID, (LastName + ', ' + FirstName ) AS Fullname FROM Employee WHERE LastName = 'Jordan' Note: CONCATENATE is not a standard function in all RDBMS, and you should use the "+" operator for Microsoft SQL Server and "||" for Oracle to concatenate the last name and first name values. Page 98: Incorrect Dept_ID In Table ----------------------------------- On page 98, in the table at the top, in the fourth row, Change: "Dept_ID 3" To: "Dept_ID 2" And in the fifth row, Change: "Dept_ID 4" To: "Dept_ID 3" Page 130: Replace Code in Listing 4-27 -------------------------------------- On page 130, in listing 4-27, change the final line of code from: EXEC sp_xml_removeDocument @hXmlDoc To: EXEC sp_xml_removeDocument @xmlHnd Page 140: Line Missing From Results of Listing 4-32 --------------------------------------------------- The expected results table shown on page 140 is missing a row. Add the following row for record 10 as the last row of the output (column headings given for reference): +------------------------------------------------+ | EMPLOYEE_NO | FIRST_NAME | LAST_NAME | DEPT_NO | +------------------------------------------------+ | 10 | Joshua | Lehman | 5 | +------------------------------------------------+ Page 196: Document Element Incorrectly Repeated In Listing 5-10 --------------------------------------------------------------- On pages 195-196, in listing 5-10, the section of code from the first line to the tag on page 196 (line 6) should be removed. The listing should begin with line 7 on page 196. Page 343: Definition For Address-Object Missing ----------------------------------------------- On page 343, the definition for the Address-Object is missing, and as a result the creation of an instance is not complete and does not lead to the XML code in the next section (The Object Instance XML Document). Add the following lines of code beneath the call to the Person constructor: Person p = new Person("John", "Smith", "11/30/1974", "brown", "blue"); p.address.setAddress1("200 Brattle Street"); p.address.setCity("Cambridge"); p.address.setState("MA"); p.address.setZip("02138"); 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: 0-7356-1185-8 WYKE REHMAN LEUPEN XML DEVBOOK ====================================================================== 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 2002.