Results 1 to 11 of 11

Thread: XML Song Catolog

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2003
    Posts
    34

    XML Song Catolog

    I have lots of information and i don't know how to put it into the correct xml format the way i have it set up now is

    <catolog>
    <artist>3 Doors Down
    <song>Changes</song>
    <song>Not Enough</song>
    </artist>
    <artist>311
    <song>All Mixed Up</song>
    <song>Beautiful Disaster</song>
    </artist>
    </catolog>

    imagine that plus 2500 songs now umm i can't get any xsl document to format it right................trying to load it into tables any idea's on how to clean this code up or make and xsl to work with it.

  2. #2
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    XSL is easy if you make a little change to the XML: enclose the artist's name in a <name> tag:
    Code:
    <artist><name>3 Doors Down</name>
    <song>Changes</song>
    <song>Not Enough</song>
    Code:
    <xsl:template match="/">
    <html>
    <body>
    <xsl:apply-templates />
    </body>
    </html>
    </xsl:template>
    
    <xsl:template match="artist">
    <h3><xsl:value-of select="name" /></h3>
    <ul>
    <xsl:apply-templates select="song" />
    </ul>
    </xsl:template>
    
    <xsl:template match="song">
    <li><xsl:copy /></li>
    </xsl:template>
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  3. #3

    Thread Starter
    Member
    Join Date
    Jan 2003
    Posts
    34
    ty i had an idea to use asp and access database instead you recomend xml or access?

  4. #4
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    I recommend mySQL and PHP...

    But that depends on your data. If it is really tree-like and you don't need fast indexed lookup then go for XML.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  5. #5

    Thread Starter
    Member
    Join Date
    Jan 2003
    Posts
    34
    umm it is a list of around 5000 6000 songs that we have available for dances(part of a mobile dj business) i need to be able to search it for songs or by artist.

    i already need a database to hold information for people that book us what do you suggest.....don't know php btw

  6. #6
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    Then database of course. And use what you're most familiar with - for me that would be PHP and MySQL, but if you don't know those you can use Access and ASP/ASP.Net too.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  7. #7

    Thread Starter
    Member
    Join Date
    Jan 2003
    Posts
    34
    can you use asp and java at same time?

    www.bassmakers.com/search.asp notice the top menu is messed up. any way to fx this

  8. #8
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    How do you use Java? As applet, as CGI, as JSP?
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  9. #9
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    Top menu works fine for me in Mozilla.

    But note that the song titles are very hard to read. The black-on-red and red-on-black alternate makes my eyes tired.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.

  10. #10

    Thread Starter
    Member
    Join Date
    Jan 2003
    Posts
    34
    any ideas for a nice color scheme?

  11. #11

    Thread Starter
    Member
    Join Date
    Jan 2003
    Posts
    34
    also in ie my menu errors it works for ie 6 with just a warning note at the bottom but ie 5 won't work at all it the display is fine but the links won't work any ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width