Hello Badtnik I've had a quick look over the page you suggest and am still puzzled. >From what I can see, the columns of the Data.Table required are assembled in Javascript on the client before the request is made.
But if I can get the JSON from the server at the moment for all columns of the table without any specific Javascript coding of column names, is it not possible to override this with a subset of columns? What I don't want is to have to manually program the construction of a result set in JSON myself for the columns I want using a database query of my own. Thanks Martin O'Shea. 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.
