Unexpected end of input error, another noob question

  • Greetings all, I'm trying to play around with XML and write a fairly basic query. I want the following query to return "SeatThree" but when I try to create the xml document first I get the error "XML parsing: line 14, character 6, unexpected end of input" I've tried to look up the error, with minimal success. Any help would be appreciated, or a point in the right direction. Is there something wrong with my code? Am I missing something major? Thanks again...

    DECLARE @abc AS XML;

    SET @abc=N'

    <usa>

    <or>

    <portland>

    <southeast>

    <hawthorn>

    <thirtyseventh>

    <BagdadTheater>SeatThree<BagdadTheater/>

    <thirtyseventh/>

    <hawthorn/>

    <southeast/>

    <portland/>

    <or/>

    <usa/>';

    I would use this Xquery code to try to return "SeatThree"

    SELECT @abc.query('data(usa/or/portland/southeast/hawthorn/37ave/BagdadTheater)') AS Element_theaterseat_data

  • The xml is invalid... the closing tag character ("/") goes at the start of the name of the xml element unless it is empty in which can you can put it at the end, but you would wouldn't have an opening and closing element in that case

    http://www.w3schools.com/xml/xml_elements.asp

    DECLARE @abc AS XML;

    SET @abc=N'

    <usa>

    <or>

    <portland>

    <southeast>

    <hawthorn>

    <thirtyseventh>

    <BagdadTheater>SeatThree</BagdadTheater>

    </thirtyseventh>

    </hawthorn>

    </southeast>

    </portland>

    </or>

    </usa>';

  • That's about as simple as it gets, thanks a ton!

    -Ben

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply