Discussion:
[visualization-api] Select clause in a querry returns errors
David Rajmon
2016-08-03 13:17:49 UTC
Permalink
Query(sheet!a1:w10) returns the whole range as expected.
Query(sheet!a1:w10,"select *") also.

When I indicate, which column to select, I get an error saying there is no such column, e.g.
Query(sheet!a1:w10,"select a")
Query(sheet!a1:w10,"select max(a)")

Why?

Any help appreciated. David
--
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+***@googlegroups.com.
To post to this group, send email to google-visualization-***@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/22492172-cf86-4582-93e2-dd16d13146ca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Douglas Parks
2016-08-15 21:22:37 UTC
Permalink
The column reference in your formula must match the column letter,
including capitalization.

Try using
Query(sheet!a1:w10,"select A")
--
Doug.
Post by David Rajmon
Query(sheet!a1:w10) returns the whole range as expected.
Query(sheet!a1:w10,"select *") also.
When I indicate, which column to select, I get an error saying there is no
such column, e.g.
Query(sheet!a1:w10,"select a")
Query(sheet!a1:w10,"select max(a)")
Why?
Any help appreciated. David
--
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+***@googlegroups.com.
To post to this group, send email to google-visualization-***@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/fff3bd93-5b6a-4231-b945-ce9d9bc2f0bb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
David Rajmon
2016-08-17 14:16:51 UTC
Permalink
Thank you Douglas.
It worked.
--
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+***@googlegroups.com.
To post to this group, send email to google-visualization-***@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/cbedddc2-fad9-4110-b654-4e236fc5fad6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Continue reading on narkive:
Search results for '[visualization-api] Select clause in a querry returns errors' (Questions and Answers)
4
replies
SQL: Calculating a complex column?
started 2010-06-04 00:14:40 UTC
programming & design
Loading...