This is of course not an Annotated time line issue, but a general problem of converting SQL dates into js dates.Once you succeed to create a data table, with a valid date or datetime column, and a valid js Date object in the value, you should be good.
I would recommend starting with a non sql based example, to make sure that all of the rest is good, and then work on converting the SQL dates to js ones. Regards, VizGuy On Wed, Apr 8, 2009 at 2:01 PM, sh al <[email protected]> wrote: > > this is my code where is my mistakes, do u know ?? > > > > { > *var* data = *new* google.visualization.DataTable(); > > data.addColumn( > 'datetime', 'Date'); // Column 0 is type string and has label "Date". > > data.addColumn( > 'number', 'Temperature'); > > data.addColumn( > 'string', 'title1'); > > data.addColumn( > 'string', 'text1'); > > data.addColumn( > 'number', 'Humidity'); > > data.addColumn( > 'string', 'title2'); > > data.addColumn( > 'string', 'text2'); > > <% *int* counter=0; > > *try*{%> > > <% > > *while*(db.rs.next()) {%> > > data.setValue( > <%=counter%>, 0, *new* Date(<%=db.rs.getInt(5)%>,<%=db.rs.getInt(6)%>,<%= > db.rs.getInt(7)%>,<%=db.rs.getInt(8)%>,<%=db.rs.getInt(9)%>,<%= > db.rs.getInt(10)%> )); // Row 0, column 0 > > data.setValue( > <%=counter%>, 1, <%=db.arrayChartData[0]%>); > > data.setValue( > <%=counter%>, 4, <%=db.arrayChartData[1]%>); > > <% counter++;} }*catch*(Exception e){}%> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
