My first guess would be that this is a column of type text and text type
cells does not have a null value, only empty strings.
So please try:
where G != ""
instead
Regards,
VizBoy.
On Wed, Jul 1, 2009 at 6:16 PM, rosalynmetz <rosalynm...@gmail.com> wrote:
>
> I have a spreadsheet that i'm querying. Below is my query:
>
> query.setQuery('SELECT E,G where G is not null');
>
> I'm selecting the columns E and G but I don't want it to appear when G
> is null. This isn't working though. Any ideas why? There isn't a
> value in some of the cells, but this query doesn't seem to work. How
> can I be sure that the cell is null. The same query but using is null
> gives me nothing.
>
> What am I missing (because clearly i'm missing something).
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-api@googlegroups.com
To unsubscribe from this group, send email to
google-visualization-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en
-~----------~----~----~----~------~----~------~--~---
