Visual Basic Discussion Boards

View All Threads

First Prev Next

Blank Asp webpage.

miss7868-Oct-12 0:08

miss786

8-Oct-12 0:08

Dear all,

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?

ASP

<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
    '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 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("date") & "' 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 - Line Chart with data from strXML
 Call renderChart("MyWeb/includes/FCF_Line.swf", "", strXML, "FactorySum", 650, 450)
%>

Any help would be very much appreciated.

Thanks in advance for your help.

Re: Blank Asp webpage.

Cloud Cray8-Oct-12 7:49

Cloud Cray

8-Oct-12 7:49

Your first tag is <graph>, but you end with </chart>

Re: Blank Asp webpage.

miss7869-Oct-12 1:14

miss786

9-Oct-12 1:14

thank you for your response and I am still getting a blank page, however this is transparent image on the page.

The page shows no error on the page but webpage is output is blank with no graph.

Any help is really much appreciated.

Thank you for your time and help.

Re: Blank Asp webpage.

Dave Kreskowiak9-Oct-12 1:51

Dave Kreskowiak

9-Oct-12 1:51

Do a "View source" on the resulting page as see what you DO get.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Blank Asp webpage.

Dave Kreskowiak9-Oct-12 1:55

Dave Kreskowiak

9-Oct-12 1:55

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Blank Asp webpage.

miss7869-Oct-12 3:54

miss786

9-Oct-12 3:54

Thank you for your response and help.

I very much appreciate your time.

Thank you.

Last Visit: 31-Dec-99 18:00 Last Update: 8-May-24 2:46

Refresh

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.