A little update: It seems that my averages haven't all populated and the #N/A values that come up are throwing the query off and making it fail (both through my query and if I use a gadget right in the spreadsheet). Any thoughts on how to deal with that or set a value if there is no data from which that aggregate can pull?
Thanks, Adam Adam Traub | Systems Librarian | St. John Fisher College | [email protected] | (585)385-8382 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Adam Traub Sent: Tuesday, October 05, 2010 2:37 PM To: Google Visualization API Subject: [visualization-api] Query Request Timing Out Hi All, I've having some issues querying the various sheets in my spreadsheet. Using a simple query and calling: var query = new google.visualization.Query( 'https://spreadsheets.google.com/ccc? key=KEYGOESHERE&hl=en&sheet=headcount&authkey=AUTHGOESHERE'); query.setQuery('SELECT C,D,E'); Works fine, but using the same query for the sheet in the same spreadsheet called "Stats:" var query = new google.visualization.Query( 'https://spreadsheets.google.com/ccc? key=KEYGOESHERE&hl=en&sheet=stats&authkey=AUTHGOESHERE'); query.setQuery('SELECT C,D,E'); Returns a "Request Timed Out" error. Any ideas? Thanks, Adam -- 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. -- 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.
