That line sets the query. "SELECT *" says "select all columns" and the
"WHERE" clause limits what is selected. "where.join(' AND ')" joins all
elements of the array into a single string separated by " AND ".
If you are using OR's in the dropdowns, then you should probably enclose
the options in parenthesis. "A = B AND M = C OR M = D" evaluates
differently from "A = B AND (M = C OR M = D)". In the first case, all
records where A = B and M = C are returned, as well as all records where M
= D, regardless of the value of A. In the second case, the parentheticals
are evaluated first, so only records where M = C or M = D are returned if A
= B.
To add more query options to the query, just add them to the array the same
as q1 and q2.
Making the table not load on page load is simple: just remove the first
call to "sendAndDraw". I tweaked the fiddle a bit to account for these
changes: http://jsfiddle.net/asgallant/wQNDW/3/
On Friday, August 10, 2012 12:16:25 PM UTC-4, ERB wrote:
>
> Also forgot to ask... I don't want the grid to load until they hit submit
> - so no auto load - which shows everything.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/2xagdcOeVfAJ.
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.
