I'm sorry I still don't follow... You said that everything works fine and the line graph was produced? So, then, what's the problem? You want to build the parameters to setValue() from what, exactly? From the database? Of course this requires server-side code.. I don't completely understand the question/problem yet.. And I'm sorry that I can't read vbscript to help you with the specifics. If someone else can, please jump in.
- VizBoy. On Tue, Mar 3, 2009 at 2:53 PM, TomP <[email protected]> wrote: > > Hi, > my code is vbscript (microsoft classic asp) going against a microsoft > sql database.. The first part of the program opens the db/table and > writes the data (date and level recording value) into a 2 dimension > table array (myarray). > I was able to succeed with the 2nd part of retrieving the data from > the myarray table and generate each data.setvalue pairs > using a server-side loop.. The line graph was produced... I was > trying to build the setvalue pairs from the database data but this > seem to work using a table.. > Regards, > TomP > > function drawVisualization() { > // Create and populate the data table. > > var data = new google.visualization.DataTable(); > data.addColumn('string', 'Date'); > data.addColumn('number', 'LevelRecorded'); > data.addRows(40); > <% > dim y, x, z, ds0, ds1 > z=0 > y=39 > x=0 > ds0=0 > ds1=0 > Do until y = -1 > %> > data.setValue(<%=ds0%>, <%=ds1%>, '<%=MyArray(x,z) > %>'); //date > data.setValue(<%=ds0%>, <%=ds1+1%>, <%=MyArray(x+1,z) > %>); //levelrecorded > > <% > x=0 > z=z+1 > ds0= ds0+1 > ds1= 0 > y = y - 1 > loop > %> > > Regards, > Tom > > On Mar 2, 12:47 pm, VizBoy <[email protected]> wrote: > > Hi, > > > > What is this code? Is it php? > > > > Try to write an example (even a small one) with pure javascript and we'll > > try to help you debug it. > > > > Regards, > > VizBoy. > > > > > > > > On Wed, Feb 25, 2009 at 4:23 PM, TomP <[email protected]> wrote: > > > > > I'm trying to generate the dataset.Value pair values coming from a > > > table. It looks like the variables i, x, ds0 and ds1 are not being > > > updated after running thru the for loop... > > > > > Is anyone doing something similar or have another way without > > > hardcoding each pair.. My input data is coming from sql database that > > > I populate in an table.. so the input can big.. > > > thanks in advance.. Tom > > > > > var y=0; > > > for (y=1;y<=6;y++) > > > { > > > > > data.setValue(ds0, ds1, '<%=MyArray(x,i+2)%>'); // > > > date > > > data.setValue(ds0, ds1+1, <%=MyArray(x+1,i+2)%>); // > > > levelrecorded > > > x=0; > > > i=i+2; > > > ds0= ds0+1; > > > ds1= 0; > > > }- Hide quoted text - > > > > - Show quoted text - > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
