Yes when I switch the urls to the spreadsheet it works fine as well I
get multiple tables.
The problem appears to be with my json_data.aspx page. I've even
copied the exact response from the spreadsheet and made my page only
return that. It still does not show more than one table. Looking at
the
Any idea what could be the issue in my response? I'm just send text/
plain content-type just like the spread sheet. I can't see to figure
out what is different.
Here is the RAW values from Fiddler from my page and google's:
[GOOGLE]
HTTP/1.1 200 OK
Content-Type: text/plain; charset=utf-8
Date: Fri, 14 Nov 2008 17:43:09 GMT
Expires: Fri, 14 Nov 2008 17:43:09 GMT
Cache-Control: private, max-age=0
Content-Length: 536
Set-Cookie: S=trix=gijqqPd8N8A; Path=/
Server: GFE/1.3
google.visualization.Query.setResponse
({requestId:'0',status:'ok',signature:'2758741876566790732',table:
{cols: [{id:'A',label:'Place / Movie',type:'t',pattern:''},
{id:'B',label:'London',type:'n',pattern:'#0.###############'},
{id:'C',label:'Paris',type:'n',pattern:'#0.###############'},
{id:'D',label:'Moscow',type:'n',pattern:'#0.###############'}],rows:
[[{v:'Pi'},{v:5.0,f:'5'},{v:25.0,f:'25'},{v:7.0,f:'7'}],[{v:'Requiem'},
{v:8.0,f:'8'},{v:20.0,f:'20'},{v:30.0,f:'30'}],[{v:'Fountain'},{v:
1.0,f:'1'},{v:3.0,f:'3'},{v:6.0,f:'6'}]]}});
[MINE]
HTTP/1.1 200 OK
Cache-Control: private
Content-Type: text/plain; charset=utf-8
Vary: Accept-Encoding
Server: Microsoft-IIS/7.0
X-AspNet-Version: 2.0.50727
X-Powered-By: ASP.NET
Date: Fri, 14 Nov 2008 17:43:07 GMT
Content-Length: 536
google.visualization.Query.setResponse
({requestId:'1',status:'ok',signature:'2758741876566790732',table:
{cols: [{id:'A',label:'Place / Movie',type:'t',pattern:''},
{id:'B',label:'London',type:'n',pattern:'#0.###############'},
{id:'C',label:'Paris',type:'n',pattern:'#0.###############'},
{id:'D',label:'Moscow',type:'n',pattern:'#0.###############'}],rows:
[[{v:'Pi'},{v:5.0,f:'5'},{v:25.0,f:'25'},{v:7.0,f:'7'}],[{v:'Requiem'},
{v:8.0,f:'8'},{v:20.0,f:'20'},{v:30.0,f:'30'}],[{v:'Fountain'},{v:
1.0,f:'1'},{v:3.0,f:'3'},{v:6.0,f:'6'}]]}});
On Nov 14, 12:27 am, VizGuy <[EMAIL PROTECTED]> wrote:
> I copied the code here, modified the urls to some publisc spreadsheets
> (http://spreadsheets.google.com/pub?key=pCQbetd-CptF0r8qmCOlZGg) and it
> worked well for me...
>
> Either there is a problem with the second url, or that you have some error
> in the code out of the snippet here...
>
> VizGuy
>
> On Fri, Nov 14, 2008 at 3:56 AM, jalbrecht <[EMAIL PROTECTED]> wrote:
>
> > Greetings,
>
> > I want to create a dashboard of multiple tables, charts, pies, etc.
> > that all call for there data independently via json.
>
> > I got my first visualization table working perfectly via the query.send
> > () call, however when I add a second call, only the first one is drawn
> > and the other table appear to time out.
>
> > What am I doing wrong?
>
> > Here is my code:
>
> > <script type="text/javascript">
> > google.load("visualization", "1", { packages: ["table"] });
> > google.setOnLoadCallback(initialize);
>
> > function initialize() {
> > // The URL here is the URL of the JSON data.
> > var stats_query = new google.visualization.Query('http://
> > jalbrecht.loopnet.com:81/json_data.aspx?d=Stats')
> > stats_query.send(drawStatsChart);
>
> > var sales_query = new google.visualization.Query('http://
> > jalbrecht.loopnet.com:81/json_data.aspx?d=Sales')
> > sales_query.send(drawSalesChart);
> > }
>
> > function drawStatsChart(response) {
> > if (isResponseOK(response, document.getElementById
> > ('StatsTable_div'))) {
> > //No error go for it.
> > var data = response.getDataTable();
> > var table = new google.visualization.Table
> > (document.getElementById('StatsTable_div'));
> > var formatter = new
> > google.visualization.TableArrowFormat();
> > formatter.format(data, 3); // Apply formatter to
> > column
> > table.draw(data, { allowHtml: true, showRowNumber:
> > false });
> > }
> > }
>
> > function drawSalesChart(response) {
> > if (isResponseOK(response, document.getElementById
> > ('SalesTable_div'))) {
> > //No error go for it.
> > var data = response.getDataTable();
> > var table = new google.visualization.Table
> > (document.getElementById('SalesTable_div'));
> > table.draw(data, { allowHtml: true, showRowNumber:
> > false });
> > }
> > }
>
> > function isResponseOK(response, el) {
> > //Check response object for error info.
> > if (response.isError()) {
> > //alert('uh oh!');
> > //Display error info in target element.
> > el.innerHTML = response.getDetailedMessage();
> > return false;
> > } else {
> > return true;
> > }
> > }
> > </script>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
