broken data line graph - please help me!

[bender]

hi everybody!

 

 

 

can anyone help me with this? i have an MS Access database which have a lot of blanks with no values in the 'dams water levels'...

 

 

 

so i'm wondering, whether i can show in my line graph that there is no reading on certain dates..eg: the line looks 'broken' for some period, then the line appears again when there's reading on that date.

 

 

 

please help me if anyone knows how...i attached my codes for everyone to see and tell me what to do...thanks a lot in advance!

mygraph.txt

[Rahul Kumar]

Hi,

Could you please try using:

$strXML = "<chart palette='2' caption='PTP' subCaption='subcaption' showValues='0' divLineDecimalPrecision='1' PYAxisName='PTP' SYAxisName='Res Lvl' formatNumberScale='0' setAdaptiveYMin='1' labelDisplay='rotate' slantLabels='1' collectNullData='0' connectNullData='1' >";

[bender]

hi Rahul, thanks for helping me...

 

 

 

but i got this error after I changed that:

 

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[PTP-1]='., SQL state 37000 in SQLExecDirect in C:wampwwwJPS Projektestptp2.php on line 58

 

37000

 

 

 

do you know what's wrong?

[Rahul Kumar]

Hi,

Could you please try the attached file?

mygraph.htm.txt

[bender]

Hi Rahul, hmm I did not find anything different between your code and my code...are you sure it is the right file?

[Rahul Kumar]

Hi,

Could you please through check your code? Because we just told you to change the attribute collectNullData='0' to connectNullData='1' that is already a string.

[bender]

I've already checked my code and I'm sure I added the connectNullData='1' correctly...but there's error

[Arindam]

hi,

  Could you please check your code that builds the XML in PHP. The code needs major debugging. The code is fetching some unnecessary data using lots of query and the XML generation is getting complicated. You might not need any other SQL query inside while loop of the primary Query. Could you please follow the code attached? Please try running it first and then modify as per your needs later. FusionCharts has no direct relation with SQL Query and records fetched. It only accepts the XML that your code generates and renders the chart. So, it

test.php.txt

[bender]

Thank you so much, Arindam!! What you suggested really solved my problem

 

 

 

I didn't know that we don't have to iterate thru each result...coz I followed the docs closely and it states that you have to iterate! Thank you so much again!

[bender]

Dear Arindam,

 

 

 

I have another inquiry, hope you don't mind..

 

 

 

my data are dams level reading according to dates. the dates are plenty and up until now and for future use too. The prob is, I dont want my x- axis to clutter with dates, so I tried just labelling x axis and remove the 'category label' part, but now the anchor values do not display the date too! how can i modify it to be just the x-axis category labels gone, but the value of date in anchor is still there? I can attach a pic of my graph if you want, so you can have a better understanding on how to help me...thanks! reply to me..

[Arindam]

hi,

Could you please use  showLabels=0