Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
miamikk
Starting Member
19 Posts |
 Posted - 2007-08-30 : 21:54:29
|
| I am newbie programmer and have a question about transforming XML file to HTML.I am not sure if XML needs to be converted to HTML for my solution or just need to append XSLT sheet to the existing XML files. I am working on developing a website that will show data in table form for selected input values. I am using BCP in SQL query to generate XML files. I used FOR XML AUTO, ELEMENTS option in BCP Command.Now I need to format it such that I can able to convert the XML file and able to display it as table on webpage.There are over 100K XML files.When I try to view XML file in browser, I get an error saying “Only one top level element is allowed in a XML document.” The error can be view from the image below.[url]http://www.fiu.edu/~atmakurk/kk/XML_Error.jpg[/url]The image of an XML file in Notepad is shown below:[url]http://www.fiu.edu/~atmakurk/kk/XML_View.jpg[/url]The actual Table view is below:[url]http://www.fiu.edu/~atmakurk/kk/Table_View1.jpg[/url]I would appreciate any help. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-31 : 05:47:35
|
| you need to wrap your xml in a single root:<root>-- your xml here.</root>_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
miamikk
Starting Member
19 Posts |
Posted - 2007-08-31 : 07:47:07
|
| And how do I wrap it ? |
|
|
|
|
|
|
XML to HTML