The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

Reply to this topicStart new topic
> Issue with XML table populating, XML
post Sep 28 2016, 10:39 AM
Post #1

Group: Members
Posts: 1
Joined: 28-September 16
Member No.: 24,863

Hello. I am having an issue with my website populating an XML table. The XML table is located in the root folder and is called song_catalog.xml

The webpage that has the XML table on it has the following code. It used to populate just fine then all of a sudden it stopped. I tried to fix it and could not. I have no idea what is going on. Any help is appreciated.

The following is the html code from the webpage, then the XML data (or rather a portion of the data since it is a huge file, well 800kb huge) .

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ""><html xmlns=""><!-- InstanceBegin template="/Templates/sitetemplate.dwt" codeOutsideHTMLIsLocked="false" -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Big Mic Productions</title>
<script src="js/songscript.js"></script>

<style type="text/css">
.catalog_genre_head {background-color:darkGray;font-size:24pt;color:white;font-family:Impact;}
.catalog_head {background-color:gray;font-size:18pt;color:white;font-family:Impact;}
.catalog_row0 {background-color:lightGray;}
.catalog_row1 {background-color:white;}
.catalog_row_end {background-color:darkGray;}
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<!--[if lte IE 7]>
.content { margin-right: -1px; } /* this 1px negative margin can be placed on any of the columns in this layout with the same corrective effect. */
ul.nav a { zoom: 1; } /* the zoom property gives IE the hasLayout trigger it needs to correct extra whiltespace between the links */
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />

<link href="css/sitestyle.css" rel="stylesheet" type="text/css" />

<style type="text/css">
body {
background-image: url(images/dj-background3.jpg);
margin-left: 30px;
margin-top: 50px;
margin-right: 30px;
margin-bottom: 50px;


<div class="container">

<div class="header" >
<img src="images/logo3.png" />
<div class="header" align="right">
<form id="form1" name="form1" method="get" action=
<INPUT TYPE="hidden" name="sitesearch" value="">
<p><label for="q">&nbsp;&nbsp;&nbsp;<b>Search Site</b></label>
&nbsp;&nbsp;<input type="text" name="q" id="q" />

<input type="submit" name="submit" id="submit"/></p>

<div class="sidebar1">
<a href="songlist2.html"><img src="images/logo 4.png" width="199" height="207" /></a>
<p><b>SONG SEARCH:</b>
What do you want to hear at your next party? Use the search below to pick out and listen to songs!
<form action="" method="get" name="form1" target="_blank" id="form1">

<label for="q"><b>Search</b></label>
<input type="text" name="q" id="q" />
<input type="submit" name="button" id="button" value="Submit" />
<!-- end .sidebar1 --></div>
<ul id="MenuBar1" class="MenuBarHorizontal">
<li><a href="index.html">Home</a> </li>
<li><a href="#" class="MenuBarItemSubmenu">Events</a>
<li><a href="weddings.html">Weddings</a></li>
<li><a href="parties.html">Parties</a></li>
<li><a href="dances.html">Dances</a></li>
<li><a href="karaoke.html">Karaoke</a></li>
<li><a href="songlist2.html">Song List</a> </li>
<li><a href="#" class="MenuBarItemSubmenu">Clients</a>
<li><a href="clientinfoform.html">Client Info</a></li>
<li><a href="feedback.html">Client Feedback</a></li>
<li><a href="#" class="MenuBarItemSubmenu">About</a>
<li><a href="aboutbigmike.html">About Big Mike</a></li>
<li><a href="testimonials.html">Testimonials</a></li>
<h3><div class="container" align="center"><!-- InstanceBeginEditable name="EditRegion3" --><p><img src="images/logo 4.png" />
<H1><b>Song Lists</b></H1>
<h3>Below you'll find a drop down list that will help you navigate your way through an enormous selection of music. These song lists will help you find any top 100 song from the past 60 years, genre-specific songs (motown, disco, 80s), or event-specific songs for your wedding (first dance, bouquet toss, father-daughter dance). If you're having trouble finding what you're looking for, just let us know. If we don't have it we will find it for your event. </h3>
<P><b>Select a category to see all related songs:</b></P>
<h1>Song List</h1>
<form name="myform">
<div onClick="getSong(document.myform.genres.value)"> <select name="genres">
<option value="First Dance" selected="selected">First Dance</option>
<option value="Top 200 Wedding Songs">Top 200 Wedding Songs</option>
<option value="50s and 60s">50s and 60s</option>
<option value="70s and Disco">70s and Disco</option>
<option value="70s Rock">70s Rock</option>
<option value="80s">80s</option>
<option value="oldschool">Old School</option>
<option value="2000s">2000s</option>
<option value="Slow Songs">Slow Songs</option>
<option value="Father/Bride Dance">Father/Bride Dance</option>
<option value="Mother/Groom Dance">Mother/Groom Dance</option>
<option value="Anniversary Dance">Anniversary Dance</option>
<option value="Cake Cutting">Cake Cutting</option>
<option value="Intro Songs">Intro Songs</option>
<option value="Dollar Dance">Dollar Dance</option>
<option value="Bouquet Toss">Bouquet Toss</option>
<option value="Garter Removal">Garter Removal</option>
<option value="Dinner Music">Dinner Music</option>
<option value="Motown">Motown</option>
<option value="Line and Group Dances">Line and Group Dances</option>
<option value="2016">2016</option>
<option value="2015">2015</option>
<option value="2014">2014</option>
<option value="2013">2013</option>
<option value="2012">2012</option>
<option value="2011">2011</option>
<option value="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<div id="output">
<!-- InstanceEndEditable -->&nbsp;</p>
<!-- InstanceBeginEditable name="EditRegion4" -->

<!-- InstanceEndEditable -->

<div class="footer">
<p>Copyright 2013 Big Mic Productions</p>
<!-- end .footer --></div>
<!-- end .container --></div>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});

<!-- InstanceEnd --></html>



<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<catalog xmlns:xsi="">
<song id="fdance1">
<artist>K-Ci and JoJo</artist>
<title>All My Life</title>
<genre>First Dance</genre>
<song id="fdance2">
<artist>Linda Ronstadt and Aaron Neville</artist>
<title>All My Life</title>
<genre>First Dance</genre>
<song id="fdance3">
<artist>Mike Reno and Ann Wilson</artist>
<title>Almost Paradise</title>
<genre>First Dance</genre>
<song id="fdance4">
<artist>Atlantic Star</artist>
<genre>First Dance</genre>
<song id="fdance5">
<title>Always And Forever</title>
<genre>First Dance</genre>
<song id="fdance6">
<genre>First Dance</genre>
<song id="fdance7">
<artist>Jeff Healey Band</artist>
<title>Angel Eyes</title>
<genre>First Dance</genre>

Thank you all in advance for your help.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Christian J
post Sep 28 2016, 01:51 PM
Post #2


Group: WDG Moderators
Posts: 8,206
Joined: 10-August 06
Member No.: 7

QUOTE(Mfortney @ Sep 28 2016, 05:39 PM) *

Hello. I am having an issue with my website populating an XML table.

Hello. Is the contents of the XML table written on the web page after making a selection in the dropdown menu? The following looks strange:

<div onClick="getSong(document.myform.genres.value)"> <select name="genres">

Clicking a DIV element around a SELECT menu (with no other content than the SELECT) is not the usual way to retrieve the value of a SELECT menu dropdown. Instead try using a button:

<input type="button" value="Search" onclick="getSong(document.myform.genres.value);">

or perhaps an onchange event in the SELECT menu itself:

<select onchange="getSong(this.value);">

(but the latter can be annoying to users).

The retrieval of the XML data seems to be done with the javascript in "js/songscript.js", which we may need to see as well if the above doesn't help.

There are some other issues with the HTML, such as the Spry menu code being inserted outside the BODY section, but they may not be related to the XML problem.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


- Lo-Fi Version Time is now: 21st August 2019 - 05:39 PM