Parameter in XML file
FusionCharts Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Parameter in XML file Expand / Collapse
Author
Message
Posted 4/10/2007 5:45:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 5/8/2007 5:44:26 PM
Posts: 1, Visits: 8
I have a Data Base in SQL Server 2000, I would like execute a Stored Procedure in ASP Page and to pass the result to XML file in the variable value. How can I do that ?   

I attach my ASP page and my XML file

-------ASP-------

<%@ language="vbscript" %>
<%

 set Conn = Server.CreateObject("ADODB.Connection")
 Conn.Open ="Driver={SQL erver};Server=IP;uid=xxx;Pwd=xxxx;database=xxx"

 Set RS = Server.CreateObject("ADODB.RecordSet")
 RS.Open "EXEC PR_PORCENTAJE 1",Conn
 x=RS(0)
Response.Write(x)
%>

------XML File --------

<Chart upperLimit="100" lowerLimit="0" baseFontColor="FFFFFF" majorTMNumber="11" majorTMColor="FFFFFF" majorTMHeight="8" minorTMNumber="5" minorTMColor="FFFFFF" minorTMHeight="3" pivotRadius="0" showHoverCap="1" hoverCapBorderColor="FFFFFF" hoverCapBgColor="333333" majorTMThickness="1" gaugeOuterRadius="100" gaugeOriginX="150" gaugeOriginY="150" gaugeScaleAngle="270" gaugeAlpha="50" dataStreamURL="RealTimeDataProvider/MeterData.asp?lowerLimit=0%26upperLimit=100" refreshInterval="5" decimalPrecision="0" placeValuesInside="1">
 <colorRange>
  <color minValue="0" maxValue="50" code="C1E1C1" />
  <color minValue="50" maxValue="85" code="F6F164" />
  <color minValue="85" maxValue="120" code="f70118" />
  </colorRange>
 <dials>
  <dial value="65.45"bordercolor="FFFFFF" bgColor="000000,cccccc,000000" borderAlpha="0" baseWidth="10" topWidth="1" />
  </dials>
 <customObjects>
 <objectGroup xPos="150" yPos="150" showBelowChart="1">
  <object type="circle" xPos="0" yPos="0" radius="145" startAngle="0" endAngle="360" fillAsGradient="1" fillColor="cccccc,111111" fillPattern="linear" fillAlpha="100,100" fillRatio="50,50" fillDegree="45" />
  <object type="circle" xPos="0" yPos="0" radius="120" startAngle="0" endAngle="360" fillAsGradient="1" fillColor="111111,cccccc" fillPattern="linear" fillAlpha="100,100" fillRatio="50,50" fillDegree="45" />
  <object type="circle" xPos="0" yPos="0" radius="110" startAngle="0" endAngle="360" color="666666" />
  </objectGroup>
 <objectGroup xPos="150" yPos="150" showBelowChart="0">
  <object type="circle" xPos="0" yPos="0" radius="10" startAngle="0" endAngle="360" borderColor="bebcb0" fillAsGradient="1" fillColor="cccccc,333333" fillAlpha="100,100" fillRatio="50,50" />
  </objectGroup>
  </customObjects>
  </Chart>

 

=) Thanks for help me !!!!

Mar

Post #800
Posted 4/11/2007 7:16:20 AM
FusionCharts Team

FusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts TeamFusionCharts Team

Group: Administrators
Last Login: 2 days ago @ 8:20:12 AM
Posts: 2,194, Visits: 521
After retrieving the data from database, you'll need to build the XML data document for the chart. This has been explained at www.fusioncharts.com/docs > Guide for Web Developers > FusionCharts and ASP.

Thanks,
Pallav Nadhani
FusionCharts Team
Post #803
« Prev Topic | Next Topic »


Permissions Expand / Collapse

All times are GMT -7:00, Time now is 7:14pm


Execution: 0.094.