Results 1 to 4 of 4
Oct 4, 2012, 02:50 #1
- Join Date
- Oct 2012
- 0 Post(s)
- 0 Thread(s)
blank webpage - displaying graphs using sql server
I am currently and learning and implementing a asp graphs webpage. I have problem, where the output is blank screen on the webpage. I have tried many possibilities to resolve this issue but I can not seem to find a solution.
<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 - Initialization Dim oRs, oRs2, strQuery 'strXML will be used to store the entire XML document generated Dim strXML 'Create the recordset to retrieve data Set oRs = Server.CreateObject("ADODB.Recordset") 'Generate the chart element strXML = "<graph caption='Factory Output report' subCaption='By Quantity' decimalPrecision='0' showNames='1' numberSuffix=' Units' pieSliceDepth='30' formatNumberScale='0'>" 'Iterate through each factory strQuery = "select * from deal_price" Set oRs = oConnection.Execute(strQuery) While Not oRs.Eof 'Now create second recordset to get details for this factory Set 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("name") & "' value='" & ors2("TotOutput") & "' />" 'Close recordset Set oRs2 = Nothing oRs.MoveNext Wend 'Finally, close <chart> element strXML = strXML & "</chart>" Response.Buffer=true response.write strXML response.flush response.end Set oRs = nothing 'Create the chart - Pie 3D Chart with data from strXML Call renderChart("MyWeb/includes/FCF_Pie2D.swf", "", strXML, "FactorySum", 650, 450) %> </BODY>
SELECT [deal_id] ,[name] ,[cusip] ,[isin] ,[size] ,[orig_price] ,[price] ,[cmbs_spread] ,[cmbs_price] ,[price_type] ,[deal_type] ,[date] FROM [dbo].[deal_price] GO
Any help would be very much appreciated. Thank you for your time and help.