Easter Sale ! -20 on bundles and top extensions !

FusionCharts for Dreamweaver - Developer Edition Forum


box FusionCharts for Dreamweaver - Developer Edition
FusionCharts is a Dreamweaver Charting Extension that can be used to render data-driven & animated charts for web applications and presentations. FusionChartsDW is a cross-browser and cross-platform solution that can be used with ASP.VB, PHP, and ColdFusion to deliver interactive and powerful flash charts.

Find out more about FusionCharts for Dreamweaver - Developer Edition

Thread: pie chart only showing 1 record?

title left
User Details
message
title right
Damion Mchenry

post date:
2010-12-10 19:09:17
I have another issue i haven\'t been able to figure out. I\'m creating a simple pie chart, and using the auto generate sql. When I do a data-preview, or preview the chart it shows up fine. But as soon as I save it and load it up on the server the pie graph just shows one slice with a \"1\" in the middle...no other labels or plots?
Damion Mchenry

post date:
2010-12-10 19:11:07
By the way, this seems to only happen on the data grouped by category...here is the code:I know it doesn't have an html code and such:<?php require_once('../Connections/ixschart.php'); ?><?php require_once('../Connections/ixschart.php'); ?><?php include('../includes/FusionCharts/dynamic/DWFChart.inc.php'); ?><?php// fusion chart # FusionChart4 data include include('../includes/FusionCharts/dynamic/data/fc_FusionChart4_data.php');if (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue;}}// fusion chart #FusionChart4 dynamic filter data //get the dates.$link = mysql_connect(HOST, OFFICIAL_USR, OFFICIAL_USR_PWRD); $db_selected = mysql_select_db(OFFICIAL_MAIN_DB, $link); $sql = "Select DATE_FORMAT(pluggins.date, '%Y') as mydate from pluggins ORDER BY pluggins.date ASC"; $result = mysql_query($sql); if ($result == false) { echo (" <p class="style1"><font color=red size=2>There was an error on this page - Error 10777ac5e. Please report this error code to the site admin</font></p>"); echo mysql_errno().":".mysql_error()."<BR>"; exit; } $numofRows = mySQL_num_rows($result); $numofRows = $numofRows - 1; $oldest = mysql_result($result, 0, "mydate"); $newest = mysql_result($result, $numofRows, "mydate"); echo "<div align = center><form action = plugginslist.php>"; for ($i = $oldest; $i < $newest; $i++){ echo "<input type = radio name = year value = "$i">$i</input>"; } echo " <input type = submit value = "View" name = "View">"; echo "</form></div>"; // fusion chart recordsetif ($_POST['year'] <> "") { $yearq = $_POST['year']; $extra = " AND DATE_FORMAT(pluggins.date, '%Y') = '$yearq' "; echo "<BR><div align = center><strong><font size = "2">Pluggins for Year $yearq</font></strong></div>";}else { echo "<BR><div align = center><strong><font size = "2">Pluggins for All Years</font></strong></div>";}mysql_select_db($database_ixschart, $ixschart);// fusion chart recordsetmysql_select_db($database_ixschart, $ixschart);$fcquery_FusionChart4_rs0 = "SELECT pluggins.cname, pluggins.cname, count(pluggins.cname) AS xtd_value FROM pluggins WHERE 1 GROUP BY pluggins.cname;";$FusionChart4_rs0 = mysql_query($fcquery_FusionChart4_rs0, $ixschart) or die(mysql_error());$row_FusionChart4_rs0 = mysql_fetch_assoc($FusionChart4_rs0);$totalRows_FusionChart4_rs0 = mysql_num_rows($FusionChart4_rs0);?><?php// fusion chart # FusionChart4 data include include('../includes/FusionCharts/dynamic/data/fc_FusionChart4_data.php');?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title><script type="text/javascript" src="../includes/FusionCharts/dynamic/js/FusionCharts.js"></script> </head><body><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue;}}?><?$dFCFusionChart4 = new DWFChart("FusionChart4", "Pie3D", "../includes/FusionCharts/charts/", 400, 400, "", "", "", "", "", "");$dFCFusionChart4->setVersion("1.1.1");$dFCFusionChart4->setConfigXML($FusionChart4_dataXML);$dFCFusionChart4->setCategory($NoRecordset, "", "", "category");$dFCFusionChart4->addSeries($FusionChart4_rs0, "pluggins.cname", "category_id_col=pluggins.cname;series_foreign_key=pluggins.id;category_label_col=pluggins.cname;category_table=pluggins;series_value_col=pluggins.cname;series_table=pluggins;series_calculation=count", "color='674295' seriesName='pluggins.cname'", "default", "");$dFCFusionChart4->setOrdering('None', 'asc');$dFCFusionChart4->prepareData(); ?><?php// (FCChart Begin) #FusionChart4renderFusionChart($dFCFusionChart4, 400, 400);// #FusionChart4 (FCChart End)?></body></html><?phpmysql_free_result($FusionChart4_rs0);?></body></html>
Cristian Dorobantescu [Extend Studio]

post date:
2010-12-11 11:21:18
Hi Damion,Please make sure you have uploaded the /includes folder on the server. Also, are the databases the same (I understand you upload it on a server)?Could you send us a link to the application at support@extendstudio.com to have a closer look?Thanks,Cristian
Gregor Meikle

post date:
2011-02-24 18:22:12
Hi,Did you get to the bottom of this problem as I am seeing the same problem.Kind RegardsGregor
Andrei Rinciog [Extend Studio]

post date:
2011-02-25 07:32:24
Hello Gregor, This is an error from the query builder that was not fixed yet. Please use recordsets instead. If you need help designing your recordsets please tell me your table structure and I can help you with the query.Regards,Andrei Rinciog