So the visualization query language is documented here<http://code.google.com/apis/visualization/documentation/dev/dsl_about.html>and works with any end point using the visualization data source library <http://code.google.com/p/google-visualization-java/>. Are you using this library ?
ChartMan On Tue, Oct 19, 2010 at 2:22 AM, Greg J <[email protected]> wrote: > I tried a different query and changed parts of it with mixed results > > in vis.php I selected the sensordesc and id fields from tempsensors > > in the graph drawing file I used the following sql for the setQuery > statement line > "select *" - SUCCESS, graph draws > "select * from tempsensors" - FAIL message box appears saying - an > error occurred: "tempsensors" > "select * order by id" - FAIL message box appears saying - an error > occurred: "sensordesc" > "select * order by id" - FAIL message box appears saying - an error > occurred: "where id < 5" > > it seems that any sql other than "select *" causes an the message box > to appear and no graph is displayed > > as stated above, this page works fine on another computer from local > mysql database on the pc. it seems to be a problem when the mysql > database is located outside the computer. > > -- > 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]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- 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.
