hi, actually I can show you my solution:
http://www.powertumbling.dk/club-ranking/ <http://www.powertumbling.dk/club-ranking/>the data comes from many sheets and is calculated using some javascript code to create a new table and display a graph. I would have liked to avoid having to code all this javascript code and do somekind of query and get the same result. but basically what I did is I did s send query for all the sheets and when I received the response I kept track that the query was done. When all sheets have returned a response I then processed a combined datatable. but the fact is keeping track of when a sheet was completed was a little tricky. Se the html code for how I did it. regards, Peter On Mon, Apr 25, 2011 at 2:00 PM, Pegasusrjf <[email protected]> wrote: > Can you give me a better idea of what you are trying to do? > > You can query both separately, by using the sheet ID (gid=#) in the > URL of the query declaration. > > On Apr 22, 12:09 pm, Peter Wraae Marino <[email protected]> > wrote: > > What is the technique used to query multiple sheets within the same > > spreadsheet. > > > > var query1 = new google.visualization.Query( <mySpreadsheet> ); > > query1.send( handleQuery1 ); > > > > var query2 = new google.visualization.Query( <mySpreadsheet> ); > > query2.send( handleQuery2 ); > > > > I would like to build a custom datatable from the response from query1 > and > > query2, so how should I go about handling this? > > I ask because the two handles will be called at different times. > > > > Peter > > -- > > Bellinge Gymnasterne:http://www.bellingegymnasterne.dk > > Power Tumbling:http://www.powertumbling.dk > > OSG-Help:http://code.google.com/p/sigmaosg > > Personal Site:http://www.marino.dk > > -- > 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. > > -- Bellinge Gymnasterne: http://www.bellingegymnasterne.dk Power Tumbling: http://www.powertumbling.dk OSG-Help: http://code.google.com/p/sigmaosg Personal Site: http://www.marino.dk -- 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.
