Click here to Skip to main content
15,888,802 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Slow Ping and not guaranteed success Pin
Eddy Vluggen15-Oct-12 1:19
professionalEddy Vluggen15-Oct-12 1:19 
QuestionFunction Not Found From Dll Component Pin
AmbiguousName10-Oct-12 1:57
AmbiguousName10-Oct-12 1:57 
AnswerRe: Function Not Found From Dll Component Pin
Eddy Vluggen11-Oct-12 0:08
professionalEddy Vluggen11-Oct-12 0:08 
GeneralRe: Function Not Found From Dll Component Pin
AmbiguousName12-Oct-12 1:07
AmbiguousName12-Oct-12 1:07 
GeneralRe: Function Not Found From Dll Component Pin
Eddy Vluggen12-Oct-12 1:25
professionalEddy Vluggen12-Oct-12 1:25 
GeneralRe: Function Not Found From Dll Component Pin
AmbiguousName12-Oct-12 1:54
AmbiguousName12-Oct-12 1:54 
GeneralRe: Function Not Found From Dll Component Pin
Eddy Vluggen12-Oct-12 2:10
professionalEddy Vluggen12-Oct-12 2:10 
QuestionBlank Asp webpage. Pin
miss7868-Oct-12 0:08
miss7868-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.
AnswerRe: Blank Asp webpage. Pin
Cloud Cray8-Oct-12 7:49
Cloud Cray8-Oct-12 7:49 
GeneralRe: Blank Asp webpage. Pin
miss7869-Oct-12 1:14
miss7869-Oct-12 1:14 
GeneralRe: Blank Asp webpage. Pin
Dave Kreskowiak9-Oct-12 1:51
mveDave Kreskowiak9-Oct-12 1:51 
GeneralRe: Blank Asp webpage. Pin
Dave Kreskowiak9-Oct-12 1:55
mveDave Kreskowiak9-Oct-12 1:55 
GeneralRe: Blank Asp webpage. Pin
miss7869-Oct-12 3:54
miss7869-Oct-12 3:54 
QuestionQuestion about variables in Classic ASP VBScript Pin
Diego Carrion7-Oct-12 5:32
Diego Carrion7-Oct-12 5:32 
AnswerRe: Question about variables in Classic ASP VBScript Pin
Brisingr Aerowing7-Oct-12 6:10
professionalBrisingr Aerowing7-Oct-12 6:10 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Diego Carrion7-Oct-12 6:19
Diego Carrion7-Oct-12 6:19 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Wes Aday7-Oct-12 6:38
professionalWes Aday7-Oct-12 6:38 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Diego Carrion7-Oct-12 7:02
Diego Carrion7-Oct-12 7:02 
GeneralRe: Question about variables in Classic ASP VBScript Pin
ChandraRam7-Oct-12 20:55
ChandraRam7-Oct-12 20:55 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Diego Carrion8-Oct-12 2:20
Diego Carrion8-Oct-12 2:20 
GeneralRe: Question about variables in Classic ASP VBScript Pin
ChandraRam8-Oct-12 2:23
ChandraRam8-Oct-12 2:23 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Diego Carrion8-Oct-12 2:26
Diego Carrion8-Oct-12 2:26 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Brisingr Aerowing7-Oct-12 6:39
professionalBrisingr Aerowing7-Oct-12 6:39 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Dave Kreskowiak7-Oct-12 8:15
mveDave Kreskowiak7-Oct-12 8:15 
GeneralRe: Question about variables in Classic ASP VBScript Pin
Diego Carrion7-Oct-12 9:25
Diego Carrion7-Oct-12 9:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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