Just some more debug info.
I created a txt file with the exact response from the spreedsheet (the
one listed in my previous post), pointed the Query object to that url
and it still only displays one table.
I moved the text file to a different server (both were IIS7) and still
same issue.
I put an alert in the function isResponseOK and when I only call the
spread sheets, it pops up twice real quick. If I call my server and
the call anything else (spread sheet or my server) the first alert
pops up right away, table is displayed, and the second alert does not
show for about 30 seconds (time out?) and no 2nd table is ever
displayed in the browser.
On Nov 14, 10:06 am, jalbrecht <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
