Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 XML ISBN: 0-7645-9792-2
This is the forum to discuss the Wrox book Professional SQL Server 2005 XML by Scott Klein; ISBN: 9780764597923
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 XML ISBN: 0-7645-9792-2 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 3rd, 2006, 04:09 PM
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Please check the code samples

This book was really rushed. We tried to use it for an in-house class and spent most of our time debugging the samples.
--Angus
Reply With Quote
  #2 (permalink)  
Old March 3rd, 2006, 04:28 PM
jminatel's Avatar
Wrox Staff
Points: 13,964, Level: 51
Points: 13,964, Level: 51 Points: 13,964, Level: 51 Points: 13,964, Level: 51
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2003
Location: Indianapolis, IN, USA.
Posts: 1,836
Thanks: 51
Thanked 106 Times in 81 Posts
Default

Angus:
Sorry to hear that. Can you give us a couple of specific examples to look at, or specific chapters you were in that caused trouble? I'm sure Scott would like to get any feedback you have.

Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press
Blog: http://wroxblog.typepad.com/
Jim's Book of the week: No book this week - Donate to the Red Cross!
Reply With Quote
  #3 (permalink)  
Old March 3rd, 2006, 04:50 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Hi Angus,

Yes, please send the examples you were using. The exmaples in this book were checked multiple times for correctness so I would be very interested in knowing what examples you were using. Also, are you using the released version of SQL Server 2005?

Reply With Quote
  #4 (permalink)  
Old March 10th, 2006, 04:37 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Angus (and all),

I have indeed found a number of instances where the examples do not work. I am currently in the process of fixing the code and will repost the code within the next couple of days. Thank you for bringing this to our attention.

Scott

Reply With Quote
  #5 (permalink)  
Old May 20th, 2006, 06:12 PM
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I bought the book today (5/20), no errata on this site, so where's the fixes for the incorrect code? The last post here was a couple of months ago.
Reply With Quote
  #6 (permalink)  
Old May 20th, 2006, 06:54 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

New code was posted a month or so ago, so if you download the code you should have the new code. Also, let me know if you find any other issues so we can get those up there as well. Keep in mind that the code was written with an early edition of Beta 2. Thank you for your email. It is greatly appreciated.

Scott

Reply With Quote
  #7 (permalink)  
Old May 20th, 2006, 07:19 PM
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the prompt reply, I fully understand the issue dealing with beta editions. When you stated you would repost the code I took it to mean here in this forum. Good to hear the corrections have been made. :D

Reply With Quote
  #8 (permalink)  
Old May 20th, 2006, 07:32 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Yes, I should have posted here when the new code was posted. My apologies, and I'll be more proactive on that. Thanks for purchasing the book. I hope you like it, and again, please let me know if you find any other issues.

Scott

Reply With Quote
  #9 (permalink)  
Old November 16th, 2007, 01:19 PM
Registered User
 
Join Date: Nov 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

The book does not show any kind of samples of shredding xml to hierarchical tables with different primary keys.

I thought it is a poor attempt by the author.

Could Scott at least give an example now please?
say shredding the attached xml to 2 tables memberheader and attributes both of which contain primary keys i.e. memHeaderID. Attributes hold a key to memHeaderID.

Thanks
roy

<LinkedMembers>
    <Member>
      <MemHeader>
        <SrcCode>B</SrcCode>
        <EID>100000</EID>
        <MemID>HSG-200</MemID>
      </MemHeader>
      <AttributeList>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>First</AttributeName>
          <Currentvalue>Lee</Currentvalue>
        </Item>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>Middle</AttributeName>
          <Currentvalue>Marvin</Currentvalue>
        </Item>
        <Item>
          <Groupname>Name</Groupname>
          <AttributeName>Last</AttributeName>
          <Currentvalue>Bruised</Currentvalue>
        </Item>
      </AttributeList>
    </Member>
    <Member>
      <MemHeader>
        <SrcCode>C</SrcCode>
        <EID>120202</EID>
        <MemID>CTX-300</MemID>
      </MemHeader>
      <AttributeList>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>First</AttributeName>
          <Currentvalue>Barry</Currentvalue>
        </Item>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>Middle</AttributeName>
          <Currentvalue>M</Currentvalue>
        </Item>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>Last</AttributeName>
          <Currentvalue>Humphries</Currentvalue>
        </Item>
        <Item>
          <Groupname>ADDRESS</Groupname>
          <AttributeName>Line1</AttributeName>
          <Currentvalue>40 Fore Street</Currentvalue>
        </Item>
      </AttributeList>
    </Member>
  </LinkedMembers>


Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code Samples qjay BOOK: Professional Microsoft Robotics Studio ISBN: 978-0-470-14107-6 17 July 13th, 2009 05:10 AM
Download code samples gmorris59 C# 2005 15 October 8th, 2007 09:39 AM
where can i get the samples code edwinomar ADO.NET 2 April 16th, 2004 01:55 PM



All times are GMT -4. The time now is 09:45 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.