reading json data from a file

reading json data from a file

I am trying to read a JSON file from a file named sites.js which seems pretty straight forward but I can't get past an error event firing. Initially I did not tell the ajax() call the datatype, and that caused the data to get written to the console as an unrecognized expression.

sites.js as exported from mySQL:

  2. [
  3. {
  4. 'Database' : 'datasite',
  5. 'Table' : 'sites',
  6. 'IP' : '192.168.0.101',
  7. 'Server' : 'ria'
  8. },
  9. {
  10. 'Database' : 'datasite',
  11. 'Table' : 'columns',
  12. 'IP' : '192.168.0.101',
  13. 'Server' : 'ria'
  14. }
  15. ]
code to read and display:
  2. var manageSites = {
  3. data: [],
  4. getSites: function(){
  5. $.ajax({
  6. type : 'get',
  7. dataType: 'json',
  8. url : 'sites.js',
  9. cache : false,
  10. error : function(){$('#manage-sites').html("Sites not found")},
  11. success : function(data){
  12. manageSites.data = $(data);
  13. manageSites.showSites();
  14. }//end success function
  15. });
  16. },
  18. showSites : function(){
  19. var key = '';
  20. var htm = '<table><thead><tr>';
  21. for(i=0; i< 1; i++){
  22.    for (key in manageSites.data[0]){
  23.        htm +='<th style="font-size:10pt;">' + key + '</th>'
  24.    }
  25.     htm += '<th style="font-size:10pt;">Remove</th></tr></thead><tbody>'
  27. };
  28.    for(i=0; i<data.length; i++){
  29.    htm +='<tr>';
  30.    htm +='<td>' + manageSites.data[i].Database + '</td>';
  31.    htm +='<td>' + manageSites.data[i].Table + '</td>';
  32.    htm +='<td>' + manageSites.data[i].IP + '</td>';
  33.    htm +='<td>' + maangeSites.data[i].Server + '</td>';
  34.    htm +='<td style="text-align:center;"><input type="checkbox"></td>';
  35.    htm +='</tr>';
  36.      
  37. };
  38. htm +='</tbody></table>';
  39. $('#manage-sites').html(htm);
  42. }
  43.        
  44. }

When I execute this after adding the dataType I get "Error sites not found", which is what is supposed to happen when something doesn't work.  In my mind I was thinking this would fire if the file couldn't be found, but that's not what is triggering the error to fire here.  Any insight is appreciated.