Your solution is much better than mine, thanks !! Send me the code snippet you are using the get the table and I will show you how to extract the count cell.
On Wed, Dec 1, 2010 at 3:53 PM, Beedrew <[email protected]> wrote: > Thanks ChartMan, > > I see what you are saying. I was hoping there was a way to query for > total results without BRINGING BACK all those results. > > I did find a way to do something similar to what you suggest by > sending a query using the count aggregation function, like this: > SELECT COUNT(A). This brings back a tiny little table with a header > ("count") and the total number of elements in Column A of my > spreadsheet (390). At least, that's what I see when I use a response > function like this: > > function draw(response) { > > if (response.isError()) { > alert('Error in query: ' + response.getMessage() + ' ' + > response.getDetailedMessage()); > return; > } > > var data = response.getDataTable(); > > var table = new > google.visualization.Table(document.getElementById('table_div')); > table.draw(data, {showRowNumber: false}); > > } > > Not being a programmer myself, I usually have to find examples and do > my best with them. Can you point me to some code that would let me > "extract" or "isolate" just the number? I know what comes back is > always a Data table, and I can't find any example code for how to pull > out just the cell value, instead of drawing it as a table. > > Thanks so much, > > Bee > -- 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.
