PDA

View Full Version : Converting XML to HTML via ASP

awesomefennis
07-04-02, 16:28
Was wonderng if anyone could help me out.
I have an xml file which contains all my mp3 on my computer. I need to convert the xml to use on a website in a nice format.

The xml file is in the following format:

<Artist>
<Album>
<Song>
<Song>
<Album>
<Song>
<Song>
<Artist>
<Album>
<Song>
<Song>
<Album>
<Song>
<Song>

Etc...


Can anyone help me out - if anyone knows of any web sites that would help me out - that would be a start.

Cheers

Fennis:cool:
awesomefennis
07-04-02, 16:30
I've just noticed that the formatting of the <Artist> etc didn't come out.

Basically it is a 3 -tier structure, Artist --> Album --> Song

Hope that helps.

elli
JonathanB
07-05-02, 05:14
Microsoft provide an XML component that allows easy use of XML in ASP scripts. The DLL is msxml.dll (version 2) or you can use msxml2.dll (version 2.6).

Go here for more information on the component:

http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28000438
buro9
07-08-02, 09:22
Note that this isn't as efficient as you'd hope.

We do the following where I work to prevent continuous calls to the XSLT to generate the HTML.

1) Construct XML files from database calls.
2) Store XML on docroot.
3) Call ASP page, check for cached HTML younger than one day in age (last modified time) and use it if present.
4) No cached HTML found, so call XSLT against XML to produce HTML.
5) Cache HTML in file but also return to user.

Sum result is that it is XML driven, it is XSL driven, it is db driven... but it only does the work once a day.

Of course this method is based on seldom changing information... but that's cool.

You could also create a totally server driven solution whereby something goes through XML on the backend, applying numerous XSLT's and splurging onto numerous docroots... static files on the front end, 100% control on the back, as many look and feels as you wish :)

cheers

david k