Dear all,

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.

Code:
   <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>
I have also dipslayed my DDL statements, which show the table I am using, for further reference.

Code:
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.