Hi, I am trying to feed my annotated graph with a data table generated by a separate php file. I thought I should be able to do this by generating JSON output in the same format as produced by the spreadsheet that was used in this Playground example: http://code.google.com/apis/ajax/playground/?type=visualization#ready_event
When I run my code, it works well when it fetches the above URL. As soon as I direct it to my php file, it produces the following 2 errors in Firebug: - Missing query for request id: undefined - Data Table is not defined At first I thought it must be something in my code, but then I tried to simplify my data table to do nothing else other than just replicate the exact same output produced by the spreadsheet above, and this still doesn't work. The file I created and its output can be found here (same output as in the spreadsheet above): http://www.kangoria.com/json.php At this point, I am starting to think that it must be something about the headers or some other information that the spreadsheet above is delivering and my file is not. Any thoughts? Here is the code I used for the file: <?php header("Content-Type: text/plain; charset=UTF-8"); $string = "google.visualization.Query.setResponse ({version:'0.6',status:'ok',sig:'261991901',table:{cols: [{id:'A',label:'Release Date',type:'date',pattern:'M/d/yyyy'}, {id:'B',label:'Budget (in dollars)',type:'number',pattern:'#0.###############'}, {id:'C',label:'Gross revenue (in the US)',type:'number',pattern:'#0.###############'},{id:'D',label:'Movie name',type:'string',pattern:''}],rows:[{c:[{v:new Date (1981,10,6),f:'11/6/1981'},{v:5000000.0,f:'5000000'},{v: 4.2365581E7,f:'42365581'},{v:'Time Bandits'}]},{c:[{v:new Date (1985,11,18),f:'12/18/1985'},{v:1.5E7,f:'15000000'},{v: 9929000.0,f:'9929000'},{v:'Brazil'}]},{c:[{v:new Date (1989,2,10),f:'3/10/1989'},{v:2.35E7,f:'23500000'},{v: 8000000.0,f:'8000000'},{v:'The Adventures of Baron Munchausen'}]},{c: [{v:new Date(1991,8,20),f:'9/20/1991'},{v:2.4E7,f:'24000000'},{v: 4.2E7,f:'42000000'},{v:'The Fisher King'}]},{c:[{v:new Date (1996,2,29),f:'3/29/1996'},{v:2.9E7,f:'29000000'},{v: 5.7141459E7,f:'57141459'},{v:'Twelve Monkeys'}]},{c:[{v:new Date (1998,4,22),f:'5/22/1998'},{v:1.85E7,f:'18500000'},{v: 1.06E7,f:'10600000'},{v:'Fear and Loathing in Las Vegas'}]},{c:[{v:new Date(2005,7,26),f:'8/26/2005'},{v:8.0E7,f:'80000000'},{v: 3.7899638E7,f:'37899638'},{v:'The Brothers Grimm'}]}]}});"; echo $string; ?> Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
