I'm soon about to give up. It is too difficult to find help or a working example of how to use auto update of Google Charts when data is located on a msSQL server.
Den tisdag 5 juli 2016 kl. 07:59:26 UTC+2 skrev Niklas Nässén: > > Hi, I can't get the refreshed data to show in the chart. > I have tried with using the JavaScript "setInterval" function, and I also > put a clock on the screen to see that its actually running, but still the > original data is shown. > Code is located on a IIS server connected to msSQL called by ASP classic, > Java Script and HTML. Clients are windows 7. > > <html> > > <head> > <script type="text/javascript" src=" > https://www.gstatic.com/charts/loader.js";></script> > <script type="text/javascript"> > google.charts.load('current', { > 'packages': ['corechart'] > }); > google.charts.setOnLoadCallback(drawChart); > > function drawChart() { > var chart = new > google.visualization.BarChart(document.getElementById('takt_diagram')); > > function updateChart() { > var d = new Date(); > document.getElementById("tid").innerHTML = > d.toLocaleTimeString(); > <% > T = DateAdd("h", DatePart("h", Now()), DateValue(Now())) > Tminus1 = DateAdd("h", -1, T) > Tminus2 = DateAdd("h", -2, T) > Tminus3 = DateAdd("h", -3, T) > Tminus4 = DateAdd("h", -4, T) > Tminus5 = DateAdd("h", -5, T) > Tminus6 = DateAdd("h", -6, T) > Tminus7 = DateAdd("h", -7, T) > Tminus8 = DateAdd("h", -8, T) > Tminus9 = DateAdd("h", -9, T) > Location = request.querystring("Loc") > set conn=Server.CreateObject("ADODB.Connection") > conn.Open > "Provider=SQLOLEDB;Server=SKSAP012\SQLEXPRESS;Database=IPS;Uid=Excel;Pwd=Krokodi1;" > > set rs=Server.CreateObject("ADODB.recordset") > rs.CursorType = adOpenStatic > SelectSats = "SELECT COUNT(*) as Total FROM [IPS].[dbo].[Loggar_SprLog] > where Loc ='" & Location & "'" > SelectNow = SelectSats & " AND Tim < '" & Now() & "' AND Tim >= '" & T & > "'" > rs.Open SelectNow, conn > h=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & T & "' AND Tim >= '" & Tminus1 & > "'" > rs.Open SelectNow, conn > i=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus1 & "' AND Tim >= '" & > Tminus2 & "'" > rs.Open SelectNow, conn > j=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus2 & "' AND Tim >= '" & > Tminus3 & "'" > rs.Open SelectNow, conn > k=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus3 & "' AND Tim >= '" & > Tminus4 & "'" > rs.Open SelectNow, conn > l=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus4 & "' AND Tim >= '" & > Tminus5 & "'" > rs.Open SelectNow, conn > m=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus5 & "' AND Tim >= '" & > Tminus6 & "'" > rs.Open SelectNow, conn > n=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus6 & "' AND Tim >= '" & > Tminus7 & "'" > rs.Open SelectNow, conn > o=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus7 & "' AND Tim >= '" & > Tminus8 & "'" > rs.Open SelectNow, conn > p=rs("Total") > rs.close > SelectNow = SelectSats & " AND Tim < '" & Tminus8 & "' AND Tim >= '" & > Tminus9 & "'" > rs.Open SelectNow, conn > q=rs("Total") > rs.close > %> > var data = new google.visualization.arrayToDataTable([ > ['Period', 'Takt'], > ['<%=Hour(T) & ".00 - " & Time() %>', <%=h%>], > ['<%=hour(Tminus1) & ".00 - " & hour(T) & ".00" %>', > <%=i%>], > ['<%=hour(Tminus2) & ".00 - " & hour(Tminus1) & ".00" > %>', <%=j%>], > ['<%=hour(Tminus3) & ".00 - " & hour(Tminus2) & ".00" > %>', <%=k%>], > ['<%=hour(Tminus4) & ".00 - " & hour(Tminus3) & ".00" > %>', <%=l%>], > ['<%=hour(Tminus5) & ".00 - " & hour(Tminus4) & ".00" > %>', <%=m%>], > ['<%=hour(Tminus6) & ".00 - " & hour(Tminus5) & ".00" > %>', <%=n%>], > ['<%=hour(Tminus7) & ".00 - " & hour(Tminus6) & ".00" > %>', <%=o%>], > ['<%=hour(Tminus8) & ".00 - " & hour(Tminus7) & ".00" > %>', <%=p%>], > ['<%=hour(Tminus9) & ".00 - " & hour(Tminus8) & ".00" > %>', <%=q%>] > ]); > var options = { > title: 'TAKT Maskin:<%=Location%>', > vAxis: { > title: 'Period' > }, > legend: { > position: 'none' > }, > isStacked: true > }; > > chart.draw(data, options); > } > updateChart(); > setInterval(updateChart, 5000); > } > </script> > </head> > > <body> > <p id="tid"></p> > <div id="takt_diagram" style="width: 1000px; height: 600px;"></div> > > </body> > > </html> > > > > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/98ffcc28-5bc3-42df-b3ae-ff162e2eab38%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
