|
|
|
Forum 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
|
|
|
|
|
FusionCharts Team
      
Group: Administrators
Last Login: Today @ 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
|
|
|
|