Hello I've used the Table Query Wrapper Example code at:
http://code.google.com/apis/visualization/documentation/examples.html#tablequerywrapper To retreieve data from a table in a MySQL database by using a URL as follows: var dataSourceUrl ='http://localhost:8080/myApp/SQLDataSource'; And hardcoding the connection parameters in the SQLDataSourceServlet provided in the downloadable examples. So, in the servlet, I have code: @Override public DataTable generateDataTable(Query query, HttpServletRequest request) throws DataSourceException { SqlDatabaseDescription dbDescription = new SqlDatabaseDescription( "jdbc:mysql://localhost:3306/myApp", "root", "password","table"); return SqlDataSourceHelper.executeQuery(query, dbDescription); } Rather than taking these values from the parameter string of the URL. This works fine and displays the table on the web page. But, it gives me all the columns of the targeted table whereas I need to be able to display only a subset of the columns. I can see nowhere where this might be done though; I have added parameters to the URL's query string using the tq instruction and have tried changing the Javascript in the tablequerywrapper.js file. But the result is always the full table. Can anyone suggest what I might be doing wrong or not doing? Thanks Martin O'Shea. -- 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.
