Charter

Members
  • Content count

    8
  • Joined

  • Last visited

About Charter

  • Rank
    Forum Newbie
  1. Which Chart To Use

    The Firebug gives it a strange setup. When I click view page source I see this Subject Code: 1014<br /><chart caption = 'Blood Pressure with Treatment' PYAxisName ='Minimum Systikuc Blood Pressure (mmHg)' SYAxisName = 'Maximum Dose of Nicardiphine (mg)' showYAxisValues='0'> <categories> <category label = 'Base' /><category label = '.25' /><category label = '.5' /><category label = '.75' /><category label = '1' /> <vLine color='FF5904' thickness='2'/> <category label = '2' /><category label = '3' /><category label = '4' /><category label = '5' /><category label = '6' /><category label = '7' /></categories><dataset seriesName = 'Max SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' /><set value = '223' /><set value = '194' /><set value = '179' /><set value = '175' /><set value = '178' /><set value = '158' /><set value = '160' /><set value = '186' /><set value = '186' /><set value = '183' /></dataset><dataset seriesName = 'Min SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' /><set value = '100' /><set value = '80' /><set value = '177' /><set value = '171' /><set value = '174' /><set value = '154' /><set value = '154' /><set value = '170' /><set value = '170' /><set value = '183' /></dataset><dataset seriesName = 'NICARDIPINE' parentYAxis = 'S' renderAs='Line'> <set value = '0' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /></dataset> <trendLines> <line startvalue= '140' color = '' displayvalue='Upper SBP Bound'/> <line startvalue= '110' color = '' displayvalue='Lower SBP Bound'/> </trendLines></chart> <!-- START Script Block for Chart Blood Pressure --> <div id='Blood PressureDiv' align='center' style='width:800;height:600;'> Chart. </div> <script type="text/javascript"><!-- //Instantiate the Chart if ( FusionCharts("Blood Pressure") && FusionCharts("Blood Pressure").dispose ) FusionCharts("Blood Pressure").dispose(); var chart_Blood Pressure = new FusionCharts( { "swfUrl" : "../../ATACHII/MSCombiDY2D.swf", "width" : "800", "height" : "600", "renderAt" : "Blood PressureDiv", "dataFormat" : "xml", "id" : "Blood Pressure", "wmode" : "opaque", "dataSource" : "<chart caption = 'Blood Pressure with Treatment' PYAxisName ='Minimum Systikuc Blood Pressure (mmHg)' SYAxisName = 'Maximum Dose of Nicardiphine (mg)' showYAxisValues='0'> <categories> <category label = 'Base' /><category label = '.25' /><category label = '.5' /><category label = '.75' /><category label = '1' /> <vLine color='FF5904' thickness='2'/> <category label = '2' /><category label = '3' /><category label = '4' /><category label = '5' /><category label = '6' /><category label = '7' /></categories><dataset seriesName = 'Max SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' /><set value = '223' /><set value = '194' /><set value = '179' /><set value = '175' /><set value = '178' /><set value = '158' /><set value = '160' /><set value = '186' /><set value = '186' /><set value = '183' /></dataset><dataset seriesName = 'Min SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' /><set value = '100' /><set value = '80' /><set value = '177' /><set value = '171' /><set value = '174' /><set value = '154' /><set value = '154' /><set value = '170' /><set value = '170' /><set value = '183' /></dataset><dataset seriesName = 'NICARDIPINE' parentYAxis = 'S' renderAs='Line'> <set value = '0' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '5' /></dataset> <trendLines> <line startvalue= '140' color = '' displayvalue='Upper SBP Bound'/> <line startvalue= '110' color = '' displayvalue='Lower SBP Bound'/> </trendLines></chart>" } ).render(); // --></script> <!-- END Script Block for Chart Blood Pressure --> It seems like this is the correct format for the xml. Am I missing something?
  2. Which Chart To Use

    I don't know how to get the debug window to show up with my style of code(asp(not class)) I looked at the linked page but couldn't find it for regular asp. So if you could give me directions on where to add the parameter that would be great. below is the firebug printout. And since I some how can't upload any files right now I am going to just paste the code. Some reason I had to delete some of the html because it has "more emoticons that this board allows." just fyi it should be than <html> <head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title>Blood Pressure Chart</title> <link type="text/css" rel="stylesheet" href="../assets/ui/css/style.css"> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <HTML><HEAD><TITLE>The page cannot be found</TITLE> <META HTTP-EQUIV="Content-Type" Content="text/html; charset=Windows-1252"> <STYLE type="text/css"> BODY { font: 8pt/12pt verdana } H1 { font: 13pt/15pt verdana } H2 { font: 8pt/12pt verdana } A:link { color: red } A:visited { color: maroon } </STYLE> </HEAD><BODY><TABLE width=500 border=0 cellspacing=10><TR><TD> <h1>The page cannot be found</h1> The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. <hr> <p>Please try the following:</p> <ul> <li>Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.</li> <li>If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted. </li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li> </ul> <h2>HTTP Error 404 - File or directory not found.<br>Internet Information Services (IIS)</h2> <hr> <p>Technical Information (for support personnel)</p> <ul> <li>Go to <a href="http://go.microsoft.com/fwlink/?linkid=8180">Microsoft Product Support Services</a> and perform a title search for the words <b>HTTP</b> and <b>404</b>.</li> <li>Open <b>IIS Help</b>, which is accessible in IIS Manager (inetmgr), and search for topics titled <b>Web Site Setup</b>, <b>Common Administrative Tasks</b>, and <b>About Custom Error Messages</b>.</li> </ul> </TD></TR></TABLE></BODY></HTML> </link> <script src="jquery.min.js" type="text/javascript"> </script> <style type="text/css"> body,html,head,div{height:100%; min-height:100%;width:100%; } </style> <script src="ATACHII/FusionCharts.js" language="Javascript"> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <HTML><HEAD><TITLE>The page cannot be found</TITLE> <META HTTP-EQUIV="Content-Type" Content="text/html; charset=Windows-1252"> <STYLE type="text/css"> BODY { font: 8pt/12pt verdana } H1 { font: 13pt/15pt verdana } H2 { font: 8pt/12pt verdana } A:link { color: red } A:visited { color: maroon } </STYLE> </HEAD><BODY><TABLE width=500 border=0 cellspacing=10><TR><TD> <h1>The page cannot be found</h1> The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. <hr> <p>Please try the following:</p> <ul> <li>Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.</li> <li>If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted. </li> <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li> </ul> <h2>HTTP Error 404 - File or directory not found.<br>Internet Information Services (IIS)</h2> <hr> <p>Technical Information (for support personnel)</p> <ul> <li>Go to <a href="http://go.microsoft.com/fwlink/?linkid=8180">Microsoft Product Support Services</a> and perform a title search for the words <b>HTTP</b> and <b>404</b>.</li> <li>Open <b>IIS Help</b>, which is accessible in IIS Manager (inetmgr), and search for topics titled <b>Web Site Setup</b>, <b>Common Administrative Tasks</b>, and <b>About Custom Error Messages</b>.</li> </ul> </TD></TR></TABLE></BODY></HTML> </script> </head> <body> <div class="Blood Pressure" style="width:800px; height:800px;"> Subject Code: 1014 <br> <chart showyaxisvalues="0" syaxisname="Maximum Dose of Nicardiphine (mg)" pyaxisname="Minimum Systikuc Blood Pressure (mmHg)" caption="Blood Pressure with Treatment"> <categories> <category label="Base"> <category label=".25"> <category label=".5"> <category label=".75"> <category label="1"> <vline label="First Hour" color="FF5904"> <category label="2"> <category label="3"></category> </category> </vline> </category> </category> </category> </category> </category> </categories> <dataset renderas="Line" parentyaxis="P" seriesname="Max SBP"> <set value="0"> <set value="215"> <set value="195"> <set value="166"> <set value="120"> <set value="121"> <set value="98"></set> </set> </set> </set> </set> </set> </set> </dataset> <dataset renderas="Line" parentyaxis="P" seriesname="Min SBP"> <set value="0"> <set value="210"> <set value="195"> <set value="162"> <set value="119"> <set value="121"> <set value="98"></set> </set> </set> </set> </set> </set> </set> </dataset> <dataset renderas="Line" parentyaxis="S" seriesname="NICARDIPINE"> <set value="0"> <set value="5"> <set value="5"> <set value="5"> <set value="7.5"> <set value="7.5"> <set value="0"></set> </set> </set> </set> </set> </set> </set> </dataset> <trendlines> <line displayvalue="Upper SBP Bound" color="" startvalue="140"> <line displayvalue="Lower SBP Bound" color="" startvalue="110"> </line> </line> </trendlines> </chart> <div id="Blood PressureDiv" align="center"> Chart. </div> <script type="text/javascript"> //Instantiate the Chart var chart_Blood Pressure = new FusionCharts("MSCombiDY2D.swf", "Blood Pressure", "800", "600"); //Provide entire XML data using dataXML method chart_Blood Pressure.setDataXML("<chart caption = 'Blood Pressure with Treatment' PYAxisName ='Minimum Systikuc Blood Pressure (mmHg)' SYAxisName = 'Maximum Dose of Nicardiphine (mg)' showYAxisValues='0'> <categories> <category label = 'Base' /><category label = '.25' /><category label = '.5' /><category label = '.75' /><category label = '1' /> <vLine color='FF5904' Label='First Hour' /><category label = '2' /><category label = '3' /></categories><dataset seriesName = 'Max SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' /><set value = '215' /><set value = '195' /><set value = '166' /><set value = '120' /><set value = '121' /><set value = '98' /></dataset><dataset seriesName = 'Min SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' /><set value = '210' /><set value = '195' /><set value = '162' /><set value = '119' /><set value = '121' /><set value = '98' /></dataset><dataset seriesName = 'NICARDIPINE' parentYAxis = 'S' renderAs='Line'> <set value = '0' /><set value = '5' /><set value = '5' /><set value = '5' /><set value = '7.5' /><set value = '7.5' /><set value = '0' /></dataset> <trendLines> <line startvalue= '140' color = '' displayvalue='Upper SBP Bound'/> <line startvalue= '110' color = '' displayvalue='Lower SBP Bound'/> </trendLines></chart>"); //Finally, render the chart. chart_Blood Pressure.render("Blood PressureDiv"); </script> </div> </body> </html>
  3. I am having the same error with my code! I think it might be with how I am adding my dataset... Here is my code <%@ Language=VBScript %> <!-- #INCLUDE file="FusionCharts.asp" --> <!-- #INCLUDE file="DBConn.asp" --> <!--#include file="FusionCharts_Gen.asp"--> <html > <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Blood Pressure Chart</title> <link href="../assets/ui/css/style.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="jquery.min.js"></script> <script LANGUAGE="Javascript" SRC="FusionCharts.js"></SCRIPT> </head> <body> <div class="Blood Pressure"> <% Dim subjectCode,subjectID,treatmentCode,baseline,count, motherID,x,z Dim FC,strQuery,Hours(27),strCategory,upper, lower z=0 hours(0) = ".25" hours(1) = ".5" hours(2) = ".75" hours(3) = "1" hours(4) = "2" hours(5) = "3" hours(6) = "4" hours(7) = "5" hours(8) = "6" hours(9) = "7" hours(10) = "8" hours(11) = "9" hours(12) = "10" hours(13) = "11" hours(14) = "12" hours(15) = "13" hours(16) = "14" hours(17) = "15" hours(18) = "16" hours(19) = "17" hours(20) = "18" hours(21) = "19" hours(22) = "20" hours(23) = "21" hours(24) = "22" hours(25) = "23" hours(26) = "24" subjectCode = Request.QueryString("subjectCode") Response.Write("Subject Code: " & subjectCode & "<br />") set FC = new FusionCharts Set oConn = Server.CreateObject("ADODB.Connection") Set oRs = Server.CreateObject("ADODB.Recordset") Call FC.setChartType("MSCombiDY2D") Call FC.setSWFPath("../ATACHII/") Call FC.setSize("800","800") oConn.Open strConnQuery strQuery="Select z.ID as totOutput, d.zTreatmentCode as totOutput2 from vSubjectDemographics d, zSubject z where z.zsubjectCode = d.zSubjectCode AND z.zSubjectCode = "&subjectCode&" "'get treatment and subjectID Set oRs = oConn.Execute(strQuery) subjectid = oRs("totOutput") treatmentCode = oRs("totOutput2") if treatmentCode=1 then'figure out upper/lower bound of BP from treatment upper=140 lower=110 else upper=180 lower=141 end if strQuery="Select ID as mother from F05 where zsubjectID = "&subjectID&" " 'get baseline and motherFormID set oRs = oConn.Execute(strQuery) motherID = oRs("mother") strQuery= "Select count(ID) as totOutput from F05C where MotherRecID = "&motherID&" "'get number of hours assessed set oRs = oConn.Execute(strQuery) count = oRs("totOutput") x=0 strParam = "caption = Blood Pressure with Treatment; PYAxisName =Minimum Systikuc Blood Pressure (mmHg) ;SYAxisName = Maximum Dose of Nicardiphine (mg); xAxisName=Hours" Call FC.setChartParams(strParam) '<vLine color='FF5904' Label='First Hour' />" do while z<=3 if z = 0 then Call FC.addCategory("Baseline","","") elseif z = 1 then Call FC.createMSStDataset() Call FC.addMSStSubDataset("Max SBP","parentyAxis = P; renderas=Line") Call FC.addChartData("0","","") elseif z = 2 then ' Call FC.createMSStDataset() Call FC.addMSStSubDataset("Min SBP","parentyAxis = P;renderas=Line") Call FC.addChartData("0","","") else Call FC.addMSLineset("NICARDIPINE","parentyAxis = S;renderas=Line") Call FC.addMSLinesetData("0","","") end if do while x<count strQuery= "Select QB as Max, QC as Min, QG as Treatment from F05C where OrderNb = "&x+1&" AND MotherRecID = "&motherID&" " ' get max,min,treatment set oRs = oConn.Execute(strQuery) if z = 0 then Call FC.addCategory(""&hours(x)&"","","") response.Write(x) if x=3 then Call FC.addVTrendLine("startValue=89.5;endValue=98;color=FF0000;displayvalue=Roll. Avg") end if elseif z = 1 then response.Write(x) Call FC.addChartData(""&oRs("Max")&"","","") elseif z = 2 then Call FC.addChartData(""&oRs("Min")&"","","") response.Write(x) else Call FC.addMSLinesetData(""&oRs("Treatment")&"","","") response.Write(x) end if x=x+1 Loop response.Write("<br>") x=0 z=z+1 Loop 'Call FC.addTrendLine("startvalue= "&upper&" displayvalue=Upper SBP Bound") 'Call FC.addTrendLine("startvalue= "&lower&" displayvalue=Lower SBP Bound") call FC.SetRenderer( "javascript" ) call FC.renderChart(false) Set oRs = Nothing response.Write(strCategory) oConn.Close %> </div> </body> </html> I looked up where the error is in the FusionCharts_Gen.asp and this is the part. Private Function getMultiDataSet() Dim partXML, Col, Key, i If seriesType>1 Then partXML="" ' Fetch dataSet Collections set Col=dataSet.getCollections() Key=Col.Keys for i=0 to Col.count -1 partXML = partXML & "<dataset " & dataSetParam(Key(i)) & " >" ' THIS LINE IS WHERE THE ERROR IS...... response.Write("here") dim Key1, Col1, j set Col1=dataSet(Key(i)).getCollections() Key1= Col1.Keys for j=0 to Col1.count -1 If dataSet(Key(i))(Key1(j)) <> "" Then ' adding elements partXML = partXML & dataSet(Key(i))(Key1(j)) End If Next partXML = partXML & "</dataset>" Next ' Return dataset element getMultiDataSet = partXML End If End Function
  4. Which Chart To Use

    I double checked and all four of them are located in the same folder
  5. Which Chart To Use

    I double checked my paths for the files and their location and they are correct. Do you have any other ideas? I can repost code if needed. I also noticed that in my code near the bottom I was missing the </div> but that didn't do anything for me....
  6. Which Chart To Use

    I have written the code for the chart and I can see the xml using FireBug when I am on the page but I just get a blank screen that says chart. I have the 4 javascript files/swf/and FusionCharts.asp in the same folder . Here is my code. Any ideas? <% 'Dim oConn if not isObject(oConn) then 'Dim strConnQuery Set oConn = Server.CreateObject("ADODB.Connection") oConn.Mode = 3 strConnQuery = " Driver={SQL Server};Server=*;DATABASE=*;UID=*;PWD=*" oConn.Open strConnQuery end if Dim subjectCode,subjectID,treatmentCode,baseline,count, motherID,x Dim FC,strQuery,Hours(27),strCategory, strValueMax, strValueMin,strValueTreat,upper, lower hours(0) = ".25" hours(1) = ".5" hours(2) = ".75" hours(3) = "1" hours(4) = "2" hours(5) = "3" hours(6) = "4" hours(7) = "5" hours(8) = "6" hours(9) = "7" hours(10) = "8" hours(11) = "9" hours(12) = "10" hours(13) = "11" hours(14) = "12" hours(15) = "13" hours(16) = "14" hours(17) = "15" hours(18) = "16" hours(19) = "17" hours(20) = "18" hours(21) = "19" hours(22) = "20" hours(23) = "21" hours(24) = "22" hours(25) = "23" hours(26) = "24" subjectCode = Request.QueryString("subjectCode") Response.Write("Subject Code: " & subjectCode & "<br />") Set oConn = Server.CreateObject("ADODB.Connection") Set oRs = Server.CreateObject("ADODB.Recordset") oConn.Open strConnQuery strQuery="Select z.ID as totOutput, d.zTreatmentCode as totOutput2 from [ATACH2].[dbo].[vSubjectDemographics] d, zSubject z where z.zSubjectCode = "&subjectCode&" AND z.zsubjectCode = d.zSubjectCode "'get treatment and subjectID Set oRs = oConn.Execute(strQuery) subjectid = oRs("totOutput") treatmentCode = oRs("totOutput2") if treatmentCode=1 then'figure out upper/lower bound of BP from treatment upper=140 lower=110 else upper=180 lower=141 end if strQuery="Select ID as mother from F05 where zsubjectID = "&subjectID&" " 'get baseline and motherFormID set oRs = oConn.Execute(strQuery) 'DELETE ONE OF THEM baseline = 80 'oRs("totOutput") ' baseline = oRs("totOutput2") Q09a as totOutput, Q09b as totOutput2, motherID = oRs("mother") strQuery= "Select count(ID) as totOutput from [ATACH2].[dbo].[F05C] where MotherRecID = "&motherID&" "'get number of hours assessed set oRs = oConn.Execute(strQuery) count = oRs("totOutput") x=0 strCategory = "<chart caption = 'Blood Pressure with Treatment' PYAxisName ='Minimum Systikuc Blood Pressure (mmHg)' SYAxisName = 'Maximum Dose of Nicardiphine (mg)' showYAxisValues='0'> <categories> <category label = 'Base' />" strCategory = strCategory + "<category label = '"&hours(0)&"' />" strCategory = strCategory + "<category label = '"&hours(1)&"' />" strCategory = strCategory + "<category label = '"&hours(2)&"' />" strCategory = strCategory + "<category label = '"&hours(3)&"' /> <vLine color='FF5904' Label='First Hour' " strCategory = strCategory + "<category label = '"&hours(4)&"' />" strValueMax = "<dataset seriesName = 'Max SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' />" strValueMin = "<dataset seriesName = 'Min SBP' parentYAxis = 'P' renderAs='Line'> <set value = '0' />" strValueTreat = "<dataset seriesName = 'NICARDIPINE' parentYAxis = 'S' renderAs='Line'> <set value = '0' />" 'count = 6 while x < count if x > 3 then strCategory = strCategory + "<category label = '"&hours(x)&"' />" end if strQuery= "Select QB as Max, QC as Min, QG as Treatment from [ATACH2].[dbo].[F05C] where OrderNb = "&x+1&" AND MotherRecID = "&motherID&" " ' get max,min,treatment set oRs = oConn.Execute(strQuery) strValueMax = strValueMax + "<set value = '"&oRs("Max")&"' />" strValueMin = strValueMin + "<set value = '"&oRs("Min")&"' />" strValueTreat = strValueTreat + "<set value = '"&oRs("Treatment")&"' />" x=x+1 wend strCategory = strCategory + "</categories>" strValueMax = strValueMax + "</dataset>" strValueMin = strValueMin + "</dataset>" strValueTreat = strValueTreat + "</dataset> <trendLines> <line startvalue= '"&upper&"' color = '' displayvalue='Upper SBP Bound'/> <line startvalue= '"&lower&"' color = '' displayvalue='Lower SBP Bound'/> </trendLines></chart>" Set oRs = Nothing strCategory = strCategory + strValueMax + strValueMin + strValueTreat response.Write(strCategory) Call renderChart("MSCombiDY2D.swf","", strCategory,"Blood Pressure",800,600) oConn.Close %>
  7. Which Chart To Use

    Thanks!
  8. Which Chart To Use

    Hi I was wondering what chart I would use if I wanted 3 lines on the xy(yaxis1) part and one line on the xy(yaxis 2/right side). I thought it would be the 2d dual y combination chart but the only examples in the documentation have the bar charts and the only line is applied to the 2nd yaxis. This is what I am looking for: http://www.fusioncharts.com/demos/gallery/combination-dual-y/chart.asp?id=mscombidy2d_4