Neither appears to and all the other Google code is unchanged. I would be really grateful for any advise on this as it is really quite frustrating.
On Aug 2, 10:22 am, MartinOShea <[email protected]> wrote: > But neither does so. > > On Aug 2, 10:19 am, Oded Badt <[email protected]> wrote: > > > > > Both would work, depends what better fits your requirement. > > Badtnik > > > On Mon, Aug 2, 2010 at 12:11 PM, MartinOShea <[email protected]> wrote: > > > But where do I apply query overrides? In the SetQuery as follows in a > > > webpage / JSP: > > > > function init() { > > > query = new google.visualization.Query(dataSourceUrl); > > > query.setQuery('select UserName, DiaryEventCode from Diary where > > > DiaryEventCode = "ADM_11"'); > > > container = document.getElementById("table"); > > > options = {'pageSize': 5}; > > > sendAndDraw(); > > > } > > > > Or in the tableQuerywrapper.js code using: > > > > this.table = new google.visualization.Table(container); > > > > this.query = query; > > > this.selectQueryClause = 'whatever'; > > > this.sortQueryClause = ''; > > > this.pageQueryClause = ''; > > > this.container = container; > > > this.currentDataTable = null > > > > On Aug 2, 10:04 am, Badtnik <[email protected]> wrote: > > > > I see. > > > > Not sure this'll solve your problem, buy you might want to use a select > > > > clause in your query. > > > > See: > > >http://code.google.com/apis/visualization/documentation/querylanguage... > > > > > Badtnik > > > > > On Mon, Aug 2, 2010 at 11:09 AM, MartinOShea <[email protected]> > > > wrote: > > > > > 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]> > > > <google-visualization-api%[email protected]<api%252bunsubscri�[email protected]> > > > > > > <google-visualization-api%[email protected]<api%252bunsubscri�[email protected]> > > > <api%252bunsubscri�[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]<google-visualization-api%[email protected]> > > > <google-visualization-api%[email protected]<api%252bunsubscri�[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]<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 -- 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.
