April 26, 2011 at 6:15 am
Guys,
I am getting the following error when I open a XML file.
XML Parsing Error: not well-formed [Firefox]
Missing equals sign between attribute and attribute value. Error processing resource [IE-8]
This is how I created the XML file.
I am using SQL Server 2000
select group.groupId, group.groupname, row.hits
from <table> as group inner join <table> as row
on group.groupId = row.groupId
for xml auto
The above query executed from VB application, and the result set has been written to disk as a text file with extension ".xml".
The output should be like this.
<group groupId="1" groupname="All">
<row hits="963510"/>
< row hits="963510"/>
< row hits="963510"/>
< row hits="963510"/>
< row hits="963510"/>
< row hits="963510"/>
</group>
But, when I view the output thru notepad, it looks like below
<group groupId="1" group="All"><row hits="963510"/>< row hits="963510"/><ro
w hits="963510"/>< row hits="963510"/>< row hits="963510"/>< row hits="963510"/>
</group>
I think it is not well formatted.
If you see the end of the first line, the character “w” has been moved to the next line. Due to this I am getting the above said error when I open the file from browser.
Can anyone suggest me how to solve this?
February 11, 2012 at 10:27 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply