February 28, 2014 at 2:40 pm
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
March 1, 2014 at 12:09 am
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>';
March 1, 2014 at 9:20 am
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