Hello,

I would like to extract information from my public fusion table and display 
using the google chart / table visualization. Please take a look at the 
code and offer some assistance. I was testing in the google code playground 
using the basic/simple table code. 

Thank you..


<!--
You are free to copy and use this sample in accordance with the terms of the
Apache license (http://www.apache.org/licenses/LICENSE-2.0.html)
-->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
  <head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title>
      Google Visualization API Sample
    </title>
    <script type="text/javascript" src="http://www.google.com/jsapi";></
script>
    <script type="text/javascript">
      google.load('visualization', '1', {packages: ['table']});
    </script>
    <script type="text/javascript">
    function drawVisualization() {
     var query = new 
google.visualization.Query("https://www.google.com/fusiontables/gvizdata?tq=select
 
'HotelName', 'State' from 12jVUUBTfMcSVcZFQ_USH1pN7kKXyHSKO9r3oFsw where 
State = 'VA' order by 'HotelName' limit 100");
                query.send(handleQueryResponse);
                function handleQueryResponse(response) {
                    if (response.isError()) {
                        alert('Error in query: ' + response.getMessage() + ' 
' + response.getDetailedMessage());
                        return;
                    }
                    var data = response.getDataTable();
    
      // Create and draw the visualization.
      visualization = new google.visualization.Table(document.getElementById
('table'));
      visualization.draw(data, null);
    }
    

    google.setOnLoadCallback(drawVisualization);
    </script>
  </head>
  <body style="font-family: Arial;border: 0 none;">
    <div id="table"></div>
  </body>
</html>


-- 
You received this message because you are subscribed to the Google Groups 
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to