The following script is not reading the xml data and translating it into the graph.
The output is currently showing a blank webpage, and I am not sure why is?
<BODY><%'In this example, we show how to connect FusionCharts to a database.'For the sake of ease, we've used an Access database which is present in'../DB/FactoryDB.mdb. It just contains two tables, which are linked to each'other. 'Database Objects - InitializationDim oRs, oRs2, strQuery
'strXML will be used to store the entire XML document generatedDim strXML
'Create the recordset to retrieve dataSet oRs = Server.CreateObject("ADODB.Recordset")
'Generate the chart element'Generate the chart element
strXML = "<graph caption='Deals Output report' subCaption='By Quantity' decimalPrecision='0' showNames='1' numberSuffix=' Units' pieSliceDepth='30' formatNumberScale='0'>"'Iterate through each factory
strQuery = "select * from deal_price2"Set oRs = oConnection.Execute(strQuery)
While Not oRs.Eof
'Now create second recordset to get details for this factorySet oRs2 = Server.CreateObject("ADODB.Recordset")
strQuery = "select sum(price) as TotOutput from deal_price where deal_id=" & ors("deal_id")
Set oRs2 = oConnection.Execute(strQuery)
'Generate <set name='..' value='..'/>
strXML = strXML & "<set name='" & ors("date") & "' value='" & ors2("TotOutput") & "' />"'Close recordsetSet oRs2 = Nothing
Wend'Finally, close <chart> element
strXML = strXML & "</chart>"Response.Buffer=trueresponse.write strXML
'response.end Set oRs = nothing'Create the chart - Line Chart with data from strXMLCall renderChart("MyWeb/includes/FCF_Line.swf", "", strXML, "FactorySum", 650, 450)
Chances are really god that you're going to have to ask your question here[^] because you're trying to use a 3rd party library. The odds of someone here who has used this thing and wandering by your question are slim. If you've got questions about a library, you go to a forum dedicated to that library for the best chance of getting your questions answered.