Are you checking the query reponse's "isError" function?
On Thursday, May 8, 2014 5:34:13 PM UTC-4, John Richardson wrote: > > Hello, > > Google fusion tables sometimes returns 0 rows even though the next time I > execute the same query it returns the correct number of rows. This often > happens when I don't execute a query for a few minutes. It's almost like > it times out but still returns a valid SQL response. Here is an example > SQL statement: > > http://www.google.com/fusiontables/gvizdata?tq=SELECT 'loan_status' as > 'Loan Status', count() as 'Total' FROM > 11-6aP_3sWAtvCjhLtX7oj50gQrA3Q4lDdLEmGDIJ WHERE grade IN ('A') GROUP BY > 'loan_status' ORDER BY 'loan_status' ASC > > Occasionally, the query will timeout, and return the correct error message > from getMessage that I can catch. However, when 0 rows are returned there > is no warning or error message to catch even though I know there should be > rows. > > I am doing a data.getNumberOfRows(); to determine if the result is valid > containing rows. However, there are cases when 0 rows is the correct > result. Is there any way to ensure that the query.send() returns the > correct query result? I am confused why there is this inconsistency. > > > Thanks for your help in advance, > John > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
