i used the sql table extraction method using helper class still its the same ... either i can manipulate previous chart or the latest chart , but not both at a time, but i can draw both different diagrams using helper class.... but cannot manipulate both diagrams(using checkbox event ... which triggers tq?select x,y,z ) from the chart (or select a,b,c for diff chart....only one works ) currently i am trying to remove the cache and see weather that works
On Fri, Jul 2, 2010 at 2:02 PM, Nathan Raley <[email protected]> wrote: > You don't need to use a tcppwebbrowser component to do it, I just went into > that detail to show you the situation which I load data from and therefore > bypassed the use of the json queries. > > You can use the google data table and the queries to populate the data > table and then use the data table, rather than the query, to pull your data > for your charts. > > > On Fri, Jul 2, 2010 at 12:49 PM, Student <[email protected]> wrote: > >> Sorry I have never heard of tcppwebbrowser. >> I think we can only use it for C++ . >> Is there a way if I am using Java servlets? >> I have my entire project based on it and cant alter at the moment. >> >> On Jul 2, 12:15 pm, Nathan Raley <[email protected]> wrote: >> > You could try using the 2 queries to populate two different google data >> > tables and then try using the data table for your queries instead of the >> > actual json query. That would be my next suggestions. I haven't done >> much >> > work with json queries like you are using since my needs were a bit >> > different than yours for pulling the information, I had an embedded >> > tcppwebbrowser object which I could use to perform my queries and then >> it >> > was a matter of sending them to the javascript and using the google data >> > tables to manipulate my information. They were very easy to work with >> so >> > you might try and give it a go, shouldn't take you but a second or two >> to >> > set them up and that might help keep your json queries from getting >> mixed >> > up. >> > >> > >> > >> > On Fri, Jul 2, 2010 at 10:55 AM, Student <[email protected]> wrote: >> > > Nope, the new session idea is not working either. >> > > I even tried to open new queried charts on new browser, but it seems >> > > that the new json string generated overwrite the old json foramt. >> > > Hence we cannot requery on the old diagram in the page. >> > > However If the new charts are drawn with same json string and data >> > > format we can have multiple charts with different select quires on >> > > them. >> > > That is how google finance charts works... since it has the same query >> > > table in json formt and we are playing on top of that by clicking >> > > combobox. >> > > Well this are my thoughts....but I am really eager to know the exact >> > > problem.. >> > > If there's any other way by which we can handle the situation ? >> > >> > > On Jul 2, 11:25 am, Nathan Raley <[email protected]> wrote: >> > > > Hmm, your suggestion that it may be a session issue could be what's >> > > causing >> > > > this. Have you given that a try yet? It would definitely be worth >> > > trying >> > > > out. >> > >> > > > On Fri, Jul 2, 2010 at 10:17 AM, Student <[email protected]> >> wrote: >> > > > > The project is on personal domain so we cannot access the site >> > > > > remotely . >> > > > > My question is just that If we draw a chart and we re-quiery on it >> > > > > using url, we can remove any data column we can(select >> > > > > column1,column3). >> > > > > But when we draw a new chart(with new table query from mysqldb) >> > > > > altogether in the same browser and re-quiery it to remove a >> column we >> > > > > are still sucessfull(select newcol1,newcol2). >> > > > > But now on the previous chart we cannot requiery since the temp >> json >> > > > > is over returned by new chart. >> > > > > Thus we get internal query error in the previous chart(now if i go >> to >> > > > > previous chart tab and do select column1,column2 ...say ). >> > >> > > > > On Jul 2, 9:56 am, Nathan Raley <[email protected]> wrote: >> > > > > > Do you have a reference that we can look at for your work to see >> what >> > > > > > exactly your doing and how your doing it compared to the site >> your >> > > using >> > > > > as >> > > > > > an example? That might help us diagnose issues quicker. It >> could be >> > > a >> > > > > > number of things that could be causing this. >> > >> > > > > > On Fri, Jul 2, 2010 at 8:43 AM, Student <[email protected]> >> > > wrote: >> > >> > >http://www.google.com/finance?q=INDEXDJX:.DJI,INDEXSP:.INX,INDEXNASDA. >> > > > > .. >> > > > > > > I have made checkbox as in the above site to remove or add >> dataset >> > > as >> > > > > > > selected. >> > > > > > > The problem I am facing is >> > > > > > > In my browser when I draw diagram on query A I can play with >> > > > > > > checkbox's easily .... on that chart. >> > > > > > > But when I draw one more chart on different tab with query B I >> can >> > > see >> > > > > > > new chart drawn perfectly, but when I select >> > > > > > > and checkbox to remove a datacolumn it gives me internal >> > > error(seems >> > > > > > > as if the query is gettinng processed on the old chart and not >> the >> > > new >> > > > > > > one) >> > > > > > > And since the two charts are different altogether I always get >> an >> > > > > > > internal query error on second chart bcoz on the same browser >> it is >> > > > > > > trying to query the old json string >> > > > > > > Is there any solution to it? >> > > > > > > I wonder if I can draw new charts altogether with different >> queiry >> > > , I >> > > > > > > should be able to requery the new chart drawn and it should >> not >> > > > > > > reference to the old charts json string. >> > > > > > > I am drawing all the diagrams in the same session..... should >> I >> > > create >> > > > > > > new session for new chart drawn and then the checkbox query >> will >> > > work >> > > > > > > properly? >> > > > > > > Regards >> > > > > > > Akku >> > >> > > > > > > -- >> > > > > > > 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]><google-visualization- >> api%[email protected] <api%[email protected]> >> ><google-visualization- >> > > api%[email protected]<api%[email protected]>< >> api%[email protected]<api%[email protected]> >> > >> > > ><google-visualization- >> > > > > api%[email protected]<api%[email protected]> >> <api%[email protected]<api%[email protected]> >> >< >> > > api%[email protected]<api%[email protected]> >> <api%[email protected]<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]<google-visualization-api%[email protected]><google-visualization- >> api%[email protected] <api%[email protected]> >> ><google-visualization- >> > > api%[email protected]<api%[email protected]>< >> api%[email protected]<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]<google-visualization-api%[email protected]><google-visualization- >> api%[email protected] <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]<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]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > -- regards, Akshay .Y. Dange. MS in Computer Science State University of New York, Binghamton -- 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.
