I am a newbie, and not a programmer at all. I also would like to connect a Gadget (Timeseries, gauge...) to an external DB (or to an export of my DB). As far as today, reading on the web and trying I figured out that gadget (Vis Api) can show data in different ways: 1. Connecting to Google spreadsheet 2. Manual writing of desired figures "inside" the code 3. Connecting to a generated datatable on a web server (I'm not sure of this method; how can I connect my gadget - let's say from igoogle - to read such datatable?) 4. Generate the full code (eg: a shell script that automatically write the code in 3 parts: first part of the code, datatable, last part of the code) and use it as gadget or stand alone in any html page
Is there any other way? Let's see these points: 1) I could sync my data to a google spreadsheet. It works as long I use a gauge, but when I use a Timeseries, how can I dinamically change the cells interval used by the gadget? It seems to me that if I update my rows, there is no problem, but if I add some rows, I'm not able to include these in the results. Am I right? 2) Manual writing? ... impossible for timeseries... 3) If this method is right, I have 2 questions: how can I generate a datatable with a query (eg: in mysql something like select * from table_name in outfile pathfile ...) and how can I call the datatable from the gadget? 4) It sounds a bit complicated to me but probably could be done by a programmer (eg: a shell script that automatically write the 3 parts of the needed code (initial, Datatable, final part)). I'm sorry if i wrote some obviuos mistake. I'm trying to find an easy way to use V. API to show my figures as a non programmer with a basic knowledge of mysql. Any help is much appreciated. Thanks, jac On 24 Ott, 16:22, v-jacko <[EMAIL PROTECTED]> wrote: > On Oct 23, 5:09 pm, arkgroup <[EMAIL PROTECTED]> wrote: > > > yes, the question can be how to convert sql to datatable. > > Any code sample? > > Well, the sample of how to put data into a table is given above along > with pointer to google's api > > So I suspect you are currently getting your SQL server side and then > writing out HTML ? If so, it would seem your questions becomes "does > anyone of any example of how I get results from a SQL query client- > side" ? > > I'm sure there are plenty of examples on the net - if you are > currenlty transforming your SQL server side, then just return it as > XML and then make xmlhttprequest call from client to get the results > client side as xml and shove them in data table from returned xml. > > The info is all out there. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
