If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Converting XML to HTML via ASP

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-04-02, 15:28
awesomefennis awesomefennis is offline
Registered User
 
Join Date: Jul 2002
Posts: 8
Converting XML to HTML via ASP

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
Reply With Quote
  #2 (permalink)  
Old 07-04-02, 15:30
awesomefennis awesomefennis is offline
Registered User
 
Join Date: Jul 2002
Posts: 8
Unhappy Ammendment

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
Reply With Quote
  #3 (permalink)  
Old 07-05-02, 04:14
JonathanB JonathanB is offline
Registered User
 
Join Date: Feb 2002
Location: North Wales, UK
Posts: 114
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/de...entid=28000438
__________________
J^ - web | email
newsASP Developer
Reply With Quote
  #4 (permalink)  
Old 07-08-02, 08:22
buro9 buro9 is offline
Member
 
Join Date: Aug 2001
Location: London, UK
Posts: 31
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On