I wish to retrieve data from a cache table and then chart the results using javascript/chart.js. I have had numerous iterations of the code attempting to do this (none of which worked) and my latest iteration is shown below.
<html>
<head>
<title>Cache Server Page</title>
<!-- Include the Chart.js library -->
<script src="chart.umd.min.js"></script>
<csp:SQLQUERY NAME='resultSet' P1='A'>
select Value, StatsDate from Stats
</csp:SQLQUERY>
<script LANGUAGE="JavaScript">
// Initialize arrays to store data
var xValues = [];
var yValues = [];
</script>
<csp:WHILE CONDITION="resultSet.Next()">