http://lab2.oraperf.com:8070/igoogle/datasource?tabname=TEST2
http://lab2.oraperf.com:8070/igoogle/datasource?tabname=V$SYSTEM_EVENT
The datasource is a procedure in the database that will produce the json for
an table directly directly. So you can do:
var query1 = new google.visualization.Query(
'http://lab2.oraperf.com:8070/igoogle/datasource2?tabname=TEST2');
query1.setQuery('SELECT col1, col2,col3 label col1 Date, col2 Number, Col3
String');
// Send the query with a callback function.
query1.send(handleQueryResponse1);
So there is (almost) full support of the setQuery SQL.
So you can run this a procedure as part of XML DB or as a procedure that
produces the output to stdout or a file and then the file can be loaded
later.
Anjo.
On Thu, Jun 25, 2009 at 6:27 PM, Maliki Yacouba <[email protected]> wrote:
>
> May be I was not specific enough.
>
> I did read through the API reference documents and find out the two options
> to populate the DataTable: (1)Creating and Populating a DataTable in
> JavaScript and (2)Creating a Table using JavaScript Object Literal Notation
>
> My question was how can I use SQL to populate the DataTable class from
> Oracle database by adopting any of these two options.
>
> If you were sucessful in populating DataTable from Oracle databse please
> send me portion of codes.
>
> Thank,
> Maliki.
>
> ----- Original Message -----
> From: Anjo Kolk <[email protected]>
> Date: Wednesday, June 24, 2009 6:59 pm
> Subject: [visualization-api] Re: motion chart
>
> > Have a look here: http://lab4.oraperf.com/demogoogle.htmlThere you
> > will see
> > the motion chart also.
> >
> > Drop me an email if you want to try the package
> > ([email protected]).
> >
> > Anjo.
> >
> > On Wed, Jun 24, 2009 at 10:47 PM, Maliki Yacouba
> > <[email protected]>wrote:
> > >
> > > Yes, from an oracle database.
> > > thank for quick reply,
> > >
> > > ----- Original Message -----
> > > From: Anjo Kolk <[email protected]>
> > > Date: Wednesday, June 24, 2009 4:39 pm
> > > Subject: [visualization-api] Re: motion chart
> > >
> > > > What database? I am doing it directly from an Oracle database.
> > > > Anjo.
> > > >
> > > > On Wed, Jun 24, 2009 at 10:31 PM, Maliki Yacouba
> > > > <[email protected]>wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > I am working on a project to visualize genomic and proteomic
> > > > data. The
> > > > > motion chart looks promissing. However, I am asking if possible
> > > > to populate
> > > > > the row and columns of the chart table directly from a Database.
> > > > if possible
> > > > > please give me guidance.
> > > > > This is a wonderful tool, keeping improving it.
> > > > > thank you.
> > > > > Yacko.
> > > > >
> > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Anjo Kolk
> > > > Miracle Benelux
> > > > Postbus 99
> > > > 3886 ZH Garderen
> > > > The Netherlands
> > > > Mobile: +31-6-55340888
> > > > Phone: +31-577-712000
> > > >
> > > > >
> > > >
> > >
> > >
> > > >
> > >
> >
> >
> > --
> > Anjo Kolk
> > Miracle Benelux
> > Postbus 99
> > 3886 ZH Garderen
> > The Netherlands
> > Mobile: +31-6-55340888
> > Phone: +31-577-712000
> >
> > >
> >
>
>
> >
>
--
Anjo Kolk
Miracle Benelux
Postbus 99
3886 ZH Garderen
The Netherlands
Mobile: +31-6-55340888
Phone: +31-577-712000
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
