Please make sure that the requestId field in the json is not the same for
both your responses.
This might cause exactly the problem you describe, and from the examples you
sent it is not clear if you have it right.
Generally, the request id field is sent in the request, and the same value
should be sent in the response back to the client.
Since all of the responses are processed by the same static function, this
is how they are synchronized.
If you send back requestId:0 for both of them, they will both be processed
as the response for the first one, and override each other, while the second
query is left without response.
VizGuy
On Fri, Nov 14, 2008 at 8:49 PM, jalbrecht <[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
