RE: Mutiple Charts on a single page

Pallav — Tue, 30 Oct 2007 06:33:39 GMT

Hi,

Can you switch the debug mode of both charts to on - that'll give you insights into what might be going wrong.

Mutiple Charts on a single page

tstreeter — Thu, 25 Oct 2007 15:13:00 GMT

Trying to build a single page with mutiple charts on the page. I can get the first one to post but receive an invalid XML message with chart #2

The charts work fine individaully so I'm fairly confident it's how I'm calling out the second chart.

The code is as follows:

<%

Dim oRs, oRs2, strQuery
Dim strXML

Set oRs = Server.CreateObject("ADODB.Recordset")

strXML = "<chart caption='Telephone Service Factor In Percentage' pieSliceDepth='30' showBorder='1' formatNumberScale='0'>"

strQuery = "select * from Queue_Master_TSF"
Set oRs = oConn.Execute(strQuery)

While Not oRs.Eof

Set oRs2 = Server.CreateObject("ADODB.Recordset")
strQuery = "select sum(Quantity) as TotOutput from Queue_Output_TSF where GraphlabelID=" & ors("GraphlabelID")
Set oRs2 = oConn.Execute(strQuery)

strXML = strXML & "<set label='" & ors("QueueName") & "' value='" & ors2("TotOutput") & "' />"

Set oRs2 = Nothing
oRs.MoveNext
Wend

strXML = strXML & "</chart>"
Set oRs = nothing

Call renderChart("../../FusionCharts/column3D.swf", "", strXML, "FactorySum", 850, 170, false, false)

strQuery = "select * from Queue_Master_ABDN"
Set oRs = oConn.Execute(strQuery)

While Not oRs.Eof

Set oRs2 = Server.CreateObject("ADODB.Recordset")
strQuery = "select sum(Quantity) as TotOutput from Queue_Output_ABDN where GraphlabelID=" & ors("GraphlabelID")
Set oRs2 = oConn.Execute(strQuery)

strXML = strXML & "<set label='" & ors("QueueName") & "' value='" & ors2("TotOutput") & "' />"

Set oRs2 = Nothing
oRs.MoveNext
Wend

strXML = strXML & "</chart>"
Set oRs = nothing

Call renderChart("../../FusionCharts/column3D.swf", "", strXML, "FactorySum1", 850, 170, false, false)

%>

FusionCharts Forum / FusionCharts Free / General Usage / Mutiple Charts on a single page / Latest Posts

RE: Mutiple Charts on a single page

Mutiple Charts on a single page