Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unexpected end of input error, another noob question Expand / Collapse
Author
Message
Posted Friday, February 28, 2014 2:40 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 3:38 PM
Points: 71, Visits: 195
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

Post #1546585
Posted Saturday, March 1, 2014 12:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:21 AM
Points: 2,622, Visits: 1,642
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>';

Post #1546625
Posted Saturday, March 1, 2014 9:20 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 3:38 PM
Points: 71, Visits: 195
That's about as simple as it gets, thanks a ton!

-Ben
Post #1546641
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse