I'm currently querying a google spreadsheet directly for my data.
Generally speaking, it works really smoothly. My only issue is that I
haven't worked out how to manipulate the spreadsheet query process.
For example, say I'd like to draw only the data points from the
spreadsheet in which the value in column A is "Boston Red Sox". The
following doesn't work:
query.setQuery('SELECT * WHERE A='Boston Red Sox')
Without the WHERE, it works fine, so the rest of the code is okay. Is
there specific Google spreadsheet syntax that I should be using?
More generally speaking, would the more experienced users suggest that
I use MySQL or stick with Google Spreadsheets. From my understanding,
with MySQL, I'd have to recreate the data table in the html then run
it through google visualizations, whereas querying google spreadsheets
doesn't need that intermediate step of having to recreate the data
table. Is this correct? Are there any speed issues relating to the
MySQL approach if I'm drawing a large data (more than 2500 data
points) then passing it through Visualizations? Am I missing any
functionality by using Google spreadsheets instead of the PHP+MySQL
approach?
Thanks a lot in advance - we beginners appreciate your help.
--
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.
