Hi,
I am currently evaluating FusionWidgets for purchase. I am getting an "error loading data" message when calling the setdataURL method on my chart. I have seen the many posts here regarding URL encoding and it seems to me like I am doing that correctly. Everytthing works fine if I put the created XML into a file and reference that in the setdataURl method or if I hard code the paramters in my getdata.php page and just put the name getdata.php in the setdataURL method call.
When I use escape() around my URL string I get an error loading data.
Here is my code:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Labor Analysis</title>
</head>
<body>
<?php
require('./includes/connection.inc.php');
include('./includes/lib.inc.php');
?>
<script language="JavaScript" src="Charts/FusionCharts.js"></script>
<form name="dropdown">
<p>Store: <!-- Drop-down Box queries Stores table in laboranalysis -->
<?php dropdown('StoreNumber', 'StoreNumber', 'store', 'StoreNumber', 'store1', 'UpdateChart()'); ?>
Date: <!-- Drop-down Box queries Punchdetail table in laboranalysis -->
<?php dropdown('date', 'date', 'available_dates', 'date', 'date1', 'UpdateChart()', '%m/%d/%y'); ?>
</form>
</p>
<div id="chartdiv" align="center">
The chart will appear within this DIV. This text will be replaced by the chart.
</div>
<script type="text/javascript">
var myChart = new FusionCharts("Charts/Gantt.swf", "myChartId", "680", "480", "0", "1");
UpdateChart();
function UpdateChart() {
var URL = "getdata.php";
var encodedURL = escape("getdata.php?store=" + document.dropdown.store1.value + "&date=" + document.dropdown.date1.value);
myChart.setDataURL(encodedURL);
alert(encodedURL);
myChart.render("chartdiv");
}
</script>
</body>
</html>
I through an alert in the code to look at the URL after it has been encoded and it looks fine to me.
Any help would be greatly appreciated.
Harry