Hi,
I trying to use arithmetic operators as described in
http://code.google.com/apis/visualization/documentation/querylanguage.html.
I'm running a query against a view in MySQL 5.0.67-community-nt. My
normal query:
query.setQuery('select regionName, total, goal where MonthYear="<%=
session.getAttribute("StartOfMonth") %>"');
works and returns my data, however when I try to use arithmetic
operators no data is returned:
query.setQuery('select regionName, (total/goal) where MonthYear="<%=
session.getAttribute("StartOfMonth") %>"');
Also tried:
query.setQuery('select total / goal where MonthYear="<%=
session.getAttribute("StartOfMonth") %>"');
And
query.setQuery('select total + goal where MonthYear="<%=
session.getAttribute("StartOfMonth") %>"');
I have checked that the types are the same. Do arithmetic operators
work when using MySQL?
Thanks,
Steve.
--
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.
