Or do I need to construct a query via the capabilities element of the SQLDataSourceServlet?
On Aug 2, 7:29 am, Badtnik <[email protected]> wrote: > Hello Martin > > Did you have a look at the DataView table > wrapper?http://code.google.com/apis/visualization/documentation/reference.htm... > > <http://code.google.com/apis/visualization/documentation/reference.htm...> > Badtnik > > > > On Mon, Aug 2, 2010 at 1:41 AM, MartinOShea <[email protected]> wrote: > > Hello > > > I've used the Table Query Wrapper Example code at: > > >http://code.google.com/apis/visualization/docu['default'], > >mentation/examples.html#tablequerywrapper<http://code.google.com/apis/visualization/documentation/examples.html...> > > > 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]<google-visualization-api%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en.- Hide quoted > >text - > > - Show quoted text - -- 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.
