were you able to fix this issue. It appears I have the same issue. The handleQueryResponse never fires. If I replace with a google spreadsheet it works fine but when I replace with my datasource the callback never occurs. Below is my datasource which is created using MC_Google_Visualization php and mysql.
http://churchmeasure.com/vis.php?tq=select%20attendance_count%20from%20church_fact&tqx=reqId%3A0 On Thursday, July 28, 2011 9:12:46 PM UTC-4, Tyler Prete wrote: > > My own data source (not a google doc). I'm not implementing the full > spec, but I'm getting back the response I listed in my post. According > to the docs that is sufficient, no? > > Thanks, > Tyler > > On Jul 28, 12:00 am, Viz Kid <[email protected]> wrote: > > Hi > > > > What data source are you using? Maybe the response there is not > performed > > correctly. > > > > Viz Kid > > > > > > > > > > > > > > > > On Wed, Jul 27, 2011 at 3:44 AM, Tyler Prete <[email protected]> wrote: > > > Hello, > > > > > I'm trying to get a simple example to work. I'll paste the text below, > > > but in short, my problem is that the response my handler gets back is > > > not a queryResponse object, so I can't call isError(), getDataTable(), > > > or any of those methods on it. If I make a DataTable myself, with new > > > google.visualization.DataTable(response['table']), it works fine, but > > > I don't understand why I should need to do this. > > > > > The response I get back from my endpoint: > > > handleQueryResponse({"status":"ok","table":{"cols": > > > [{"id":"col2","label":"Date","type":"string"}, > > > {"id":"col1","label":"Revenue","type":"number"}],"rows":[{"c": > > > [{"v":"07\/23"},{"v":12.597}]},{"c":[{"v":"07\/24"},{"v":12.805}]}, > > > {"c":[{"v":"07\/25"},{"v":18.252}]},{"c":[{"v":"07\/26"},{"v": > > > 16.302}]},{"c":[{"v":"Today"},{"v":0.0455}]}]},"reqId":5}) > > > > > Source: > > > <html> > > > <head> > > > </head> > > > > > <body> > > > <script type="text/javascript" src="https://www.google.com/ > > > jsapi"></script> > > > <script type="text/javascript"> > > > google.load("visualization", "1", {packages:["corechart"]}); > > > google.setOnLoadCallback(drawChart); > > > function drawChart() { > > > var query = new google.visualization.Query( > > > 'myurl.response.listed.above'; > > > > > // Send the query with a callback function. > > > query.send(handleQueryResponse); > > > } > > > > > function handleQueryResponse(response) { > > > /* if (response.isError()) { > > > alert('Error in query: ' + response.getMessage() + ' ' + > > > response.getDetailedMessage()); > > > return; > > > } */ > > > //var data = response.getDataTable(); // Commented out because it > > > throws errors > > > var data = new google.visualization.DataTable(response['table']); > > > var chart = new > > > > google.visualization.ColumnChart(document.getElementById('chart_div')); > > > chart.draw(data, {width: 400, height: 240, title: 'Company > > > Performance', > > > hAxis: {title: 'Year', titleTextStyle: > > > {color: 'red'}} > > > }); > > > } > > > </script> > > > <div id="chart_div"></div> > > > </body> > > > </html> > > > > > -- > > > 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] <javascript:>. > > > To unsubscribe from this group, send email to > > > [email protected] <javascript:>. > > > For more options, visit this group at > > >http://groups.google.com/group/google-visualization-api?hl=en. On Thursday, July 28, 2011 9:12:46 PM UTC-4, Tyler Prete wrote: > > My own data source (not a google doc). I'm not implementing the full > spec, but I'm getting back the response I listed in my post. According > to the docs that is sufficient, no? > > Thanks, > Tyler > > On Jul 28, 12:00 am, Viz Kid <[email protected]> wrote: > > Hi > > > > What data source are you using? Maybe the response there is not > performed > > correctly. > > > > Viz Kid > > > > > > > > > > > > > > > > On Wed, Jul 27, 2011 at 3:44 AM, Tyler Prete <[email protected]> wrote: > > > Hello, > > > > > I'm trying to get a simple example to work. I'll paste the text below, > > > but in short, my problem is that the response my handler gets back is > > > not a queryResponse object, so I can't call isError(), getDataTable(), > > > or any of those methods on it. If I make a DataTable myself, with new > > > google.visualization.DataTable(response['table']), it works fine, but > > > I don't understand why I should need to do this. > > > > > The response I get back from my endpoint: > > > handleQueryResponse({"status":"ok","table":{"cols": > > > [{"id":"col2","label":"Date","type":"string"}, > > > {"id":"col1","label":"Revenue","type":"number"}],"rows":[{"c": > > > [{"v":"07\/23"},{"v":12.597}]},{"c":[{"v":"07\/24"},{"v":12.805}]}, > > > {"c":[{"v":"07\/25"},{"v":18.252}]},{"c":[{"v":"07\/26"},{"v": > > > 16.302}]},{"c":[{"v":"Today"},{"v":0.0455}]}]},"reqId":5}) > > > > > Source: > > > <html> > > > <head> > > > </head> > > > > > <body> > > > <script type="text/javascript" src="https://www.google.com/ > > > jsapi"></script> > > > <script type="text/javascript"> > > > google.load("visualization", "1", {packages:["corechart"]}); > > > google.setOnLoadCallback(drawChart); > > > function drawChart() { > > > var query = new google.visualization.Query( > > > 'myurl.response.listed.above'; > > > > > // Send the query with a callback function. > > > query.send(handleQueryResponse); > > > } > > > > > function handleQueryResponse(response) { > > > /* if (response.isError()) { > > > alert('Error in query: ' + response.getMessage() + ' ' + > > > response.getDetailedMessage()); > > > return; > > > } */ > > > //var data = response.getDataTable(); // Commented out because it > > > throws errors > > > var data = new google.visualization.DataTable(response['table']); > > > var chart = new > > > > google.visualization.ColumnChart(document.getElementById('chart_div')); > > > chart.draw(data, {width: 400, height: 240, title: 'Company > > > Performance', > > > hAxis: {title: 'Year', titleTextStyle: > > > {color: 'red'}} > > > }); > > > } > > > </script> > > > <div id="chart_div"></div> > > > </body> > > > </html> > > > > > -- > > > 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] <javascript:>. > > > To unsubscribe from this group, send email to > > > [email protected] <javascript:>. > > > For more options, visit this group at > > >http://groups.google.com/group/google-visualization-api?hl=en. On Thursday, July 28, 2011 9:12:46 PM UTC-4, Tyler Prete wrote: > > My own data source (not a google doc). I'm not implementing the full > spec, but I'm getting back the response I listed in my post. According > to the docs that is sufficient, no? > > Thanks, > Tyler > > On Jul 28, 12:00 am, Viz Kid <[email protected]> wrote: > > Hi > > > > What data source are you using? Maybe the response there is not > performed > > correctly. > > > > Viz Kid > > > > > > > > > > > > > > > > On Wed, Jul 27, 2011 at 3:44 AM, Tyler Prete <[email protected]> wrote: > > > Hello, > > > > > I'm trying to get a simple example to work. I'll paste the text below, > > > but in short, my problem is that the response my handler gets back is > > > not a queryResponse object, so I can't call isError(), getDataTable(), > > > or any of those methods on it. If I make a DataTable myself, with new > > > google.visualization.DataTable(response['table']), it works fine, but > > > I don't understand why I should need to do this. > > > > > The response I get back from my endpoint: > > > handleQueryResponse({"status":"ok","table":{"cols": > > > [{"id":"col2","label":"Date","type":"string"}, > > > {"id":"col1","label":"Revenue","type":"number"}],"rows":[{"c": > > > [{"v":"07\/23"},{"v":12.597}]},{"c":[{"v":"07\/24"},{"v":12.805}]}, > > > {"c":[{"v":"07\/25"},{"v":18.252}]},{"c":[{"v":"07\/26"},{"v": > > > 16.302}]},{"c":[{"v":"Today"},{"v":0.0455}]}]},"reqId":5}) > > > > > Source: > > > <html> > > > <head> > > > </head> > > > > > <body> > > > <script type="text/javascript" src="https://www.google.com/ > > > jsapi"></script> > > > <script type="text/javascript"> > > > google.load("visualization", "1", {packages:["corechart"]}); > > > google.setOnLoadCallback(drawChart); > > > function drawChart() { > > > var query = new google.visualization.Query( > > > 'myurl.response.listed.above'; > > > > > // Send the query with a callback function. > > > query.send(handleQueryResponse); > > > } > > > > > function handleQueryResponse(response) { > > > /* if (response.isError()) { > > > alert('Error in query: ' + response.getMessage() + ' ' + > > > response.getDetailedMessage()); > > > return; > > > } */ > > > //var data = response.getDataTable(); // Commented out because it > > > throws errors > > > var data = new google.visualization.DataTable(response['table']); > > > var chart = new > > > > google.visualization.ColumnChart(document.getElementById('chart_div')); > > > chart.draw(data, {width: 400, height: 240, title: 'Company > > > Performance', > > > hAxis: {title: 'Year', titleTextStyle: > > > {color: 'red'}} > > > }); > > > } > > > </script> > > > <div id="chart_div"></div> > > > </body> > > > </html> > > > > > -- > > > 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] <javascript:>. > > > To unsubscribe from this group, send email to > > > [email protected] <javascript:>. > > > For more options, visit this group at > > >http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/YOvFxJMPdxQJ. 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.
