okk u don't have any example, to help me in this chart ,,,,,,
thank you all for helping me On 4/10/09, VizGuy <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
