Cant get a chart to work since the new updates
Hello webassist since the databridge and design extender last update i try to create some dynamic charts, but no matter what options i select none load they are all empty when i check the file_data#.php files created by the extension the recordsets all come in with the red mark telling me they are bad i corrected them but still the charts wont load on the flash, more hair lost with this help please.
My system windows 7 64 bit with css 5.5, last extension update
my steps opened a new php file
Clicked the dynamic web charts icon
Changed the display to bars - Glass
Selected the database
on X i selected a date field and grouped by month
on Y value selected the Id of the records
On filter i selected sort by date desc
Clicked ok
The graph gets build but when i i select it in dreamweaver it doesnt allow me to edit anything like before and when i test them on the browser it loads an empty graph, when i mouse over them it says undefined.
I checked then the file_data1.php and it had a bad recordset it did not add the complete code for the sort leaving it to
mysql_select_db($database_gv2life, $gv2life);
$query_WADWCusuarios = "SELECT CONCAT( LEFT(MONTHNAME(uFecha), 3), ' ', YEAR(uFecha)) AS XLABEL, COUNT(idU) AS YVALUE FROM usuarios GROUP BY CONCAT( LEFT(MONTHNAME(uFecha), 3), ' ', YEAR(uFecha)), YEAR(uFecha), MONTH(uFecha) ORDER BY ";
so i added
mysql_select_db($database_gv2life, $gv2life);
$query_WADWCusuarios = "SELECT CONCAT( LEFT(MONTHNAME(uFecha), 3), ' ', YEAR(uFecha)) AS XLABEL, COUNT(idU) AS YVALUE FROM usuarios GROUP BY CONCAT( LEFT(MONTHNAME(uFecha), 3), ' ', YEAR(uFecha)), YEAR(uFecha), MONTH(uFecha) ORDER BY YEAR(uFecha), MONTH(uFecha) ASC";
i also added to the conection ../../../ and they kind of work now but still i cant edit it like before