mfinocc
asked on
How to pass ASP values to a javascript Google chart
How do I get my asp values to pass into the google chart below?
<%
Set rsset = Server.CreateObject("ADODB.Recordset")
sql="SELECT builder, ytd_production, weekly_production, report_date "_
& "FROM velocity_tick_history "_
& "ORDER BY weekly_production DESC"
rsset.Open sql, conn
%>
<html>
<head>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable
([
['Builder','YTD', 'Week'],
<%
do while not rsset.eof
%>
[<%=rsset("builder")%>,<%=rsset("ytd_production")%>,<%=rsset("weekly_production")%>],
<%
rsset.movenext
loop
%>
['ORL',66.36,68.94]
]);
var options = {
title: 'Velocity Tick History Report - Week of 10/21/13 - 10/25/13',
vAxis: {title: 'Builder', titleTextStyle: {color: 'red'}}
//xAxis: {title: 'Production Percentage', titleTextStyle: {color: 'blue'}}
};
var chart = new google.visualization.BarChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
</head>
<body>
<div id="chart_div" style="width: 900px; height: 700px;"></div>
</body>
</html>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.