User (Legacy) Posted February 19, 2003 Report Posted February 19, 2003 We were on version 4,5,18,1 and we just put the patch on our server to get up to 5,5,10,2 and once that got downloaded to a clients desktop the graphs stopped working. listed below is my asp code that worked in the previous version of Chart FX, but doesn't work with 5.5. It looks like the new version is bring back a dummy line chart because the data is nothing like what I am looking for plus it's bringing back 2 lines where I had only one line in the previous version and I ran the sql in the background to make sure it wasn't that end of things and it wasn't. Any help would be appreciated. ASP Code: <!-- #include file="../../Include/CfxIE.inc" --> <html> <head> </head> <body> <% Dim SPobj,Rs,Chart,sSQL,sCusip,RealCusip,iPosition RealCusip = Request.QueryString("sCusip") sSQL = "FinDatGetBond52Wk '" & RealCusip & "'" Set SPobj = Server.CreateObject("DLBSystem.clsDBFunctions") Call SPobj.GetRS(CStr(sSQL), Rs, CLng(180),"CorpSec","Connection") Set Chart = Server.CreateObject("ChartFX.WebServer") Chart.RgbBk = RGB(255,255,255) Chart.Chart3D = False Chart.Gallery = LINES Chart.AxesStyle = CAS_FLATFRAME Chart.Title(CHART_TOPTIT) = "Trailing Weekly Price History For " & RealCusip & "" Chart.AdoResultset Rs 'Chart.SerLegBox = False Chart.OpenDataEx COD_COLORS, 2, 0 Chart.Color(0) = RGB(0,0,255) Chart.CloseData COD_COLORS Chart.Fonts(CHART_TOPFT) = CF_UNDERLINE Chart.Axis(AXIS_Y).Decimals = 2 Chart.Axis(AXIS_Y).ForceZero = False Chart.RecalcScale 'Chart.Series(0).MarkerSize = 2 Chart.Toolbar = True Chart.DataEditor = True Chart.AllowDrag = False Chart.AllowEdit = False Chart.Grid = 1 'Show the horizontal lines if Chart.Axis(AXIS_Y).Min = 0 then else Chart.Axis(AXIS_Y).Min = Chart.Axis(AXIS_Y).Min - 5 end if Chart.Axis(AXIS_Y).Max = Chart.Axis(AXIS_Y).Max + 5 Chart.Axis(AXIS_Y).AdjustScale %> <%=Chart.GetHtmlTag("100%","300")%> </P> </body> </html> Also listed below is the source code of the graph page: <html> <head> </head> <body> <OBJECT CLASSID="CLSID:21F49842-BFA9-11d2-A89C-00104B62BDDA" TYPE="application/x-oleobject" WIDTH="100%" HEIGHT="300" ID="Chart1" CODEBASE=/download/CfxIEAx.cab#Version=5,5,10,2 > <PARAM NAME="LICENSE" VALUE="/license/CfxIE.lic"> <PARAM NAME="DATAPATH" VALUE="/cfxtemp/CFT0219_145727287.chw"> </OBJECT> </P> </body> </html> Thanks Ian Dalton
Software FX Posted February 19, 2003 Report Posted February 19, 2003 Looks like reading the file is failing. Can you please attach the file ="/cfxtemp/CFT0219_145727287.chw", we need to take a look to see what's wrong with it. Also, make sure the file can be downloaded. To test this, try to access it from your browser's address bar by preceding this URL with the current page's URL. For example, if your page was at www.foo.com/folder/mypage.asp, type in your browser's address bar: www.foo.com/folder/mypage/cfxtemp/CFT0219_145727287.chw If you get a "Saver as" dialog, everything is fine (then you need to send us the file to see what's wrong with it) otherwise, you have a problem that has nothing to do with upgrading to 5.5 but it has something to do maybe with re-starting your server as changes you have made to it are reflected just now. -- FP Software FX, Inc.
Software FX Posted February 19, 2003 Report Posted February 19, 2003 You may also want to check your CfxSrv.ini to make sure the new version of the client component (5.5.10.2) is pushed to your users, check the codebase and pluginpage entries. -- Regards, JC Software FX Support "Ian Dalton" <idalton@dlbabson.com> wrote in message news:ur7o#TF2CHA.1312@webserver1.softwarefx.com... > We were on version 4,5,18,1 and we just put the patch on our server to get > up to 5,5,10,2 and once that got downloaded to a clients desktop the graphs > stopped working. listed below is my asp code that worked in the previous > version of Chart FX, but doesn't work with 5.5. It looks like the new > version is bring back a dummy line chart because the data is nothing like > what I am looking for plus it's bringing back 2 lines where I had only one > line in the previous version and I ran the sql in the background to make > sure it wasn't that end of things and it wasn't. > > Any help would be appreciated. > > ASP Code: > > <!-- #include file="../../Include/CfxIE.inc" --> > <html> > <head> > </head> > <body> > <% > Dim SPobj,Rs,Chart,sSQL,sCusip,RealCusip,iPosition > > RealCusip = Request.QueryString("sCusip") > > sSQL = "FinDatGetBond52Wk '" & RealCusip & "'" > > Set SPobj = Server.CreateObject("DLBSystem.clsDBFunctions") > Call SPobj.GetRS(CStr(sSQL), Rs, CLng(180),"CorpSec","Connection") > > Set Chart = Server.CreateObject("ChartFX.WebServer") > Chart.RgbBk = RGB(255,255,255) > Chart.Chart3D = False > Chart.Gallery = LINES > Chart.AxesStyle = CAS_FLATFRAME > Chart.Title(CHART_TOPTIT) = "Trailing Weekly Price History For " & RealCusip > & "" > Chart.AdoResultset Rs > 'Chart.SerLegBox = False > Chart.OpenDataEx COD_COLORS, 2, 0 > Chart.Color(0) = RGB(0,0,255) > Chart.CloseData COD_COLORS > Chart.Fonts(CHART_TOPFT) = CF_UNDERLINE > Chart.Axis(AXIS_Y).Decimals = 2 > Chart.Axis(AXIS_Y).ForceZero = False > Chart.RecalcScale > 'Chart.Series(0).MarkerSize = 2 > > Chart.Toolbar = True > Chart.DataEditor = True > Chart.AllowDrag = False > Chart.AllowEdit = False > Chart.Grid = 1 'Show the horizontal lines > > if Chart.Axis(AXIS_Y).Min = 0 then > else > Chart.Axis(AXIS_Y).Min = Chart.Axis(AXIS_Y).Min - 5 > end if > Chart.Axis(AXIS_Y).Max = Chart.Axis(AXIS_Y).Max + 5 > Chart.Axis(AXIS_Y).AdjustScale > %> > <%=Chart.GetHtmlTag("100%","300")%> > </P> > > </body> > </html> > > Also listed below is the source code of the graph page: > > <html> > <head> > </head> > <body> > <OBJECT CLASSID="CLSID:21F49842-BFA9-11d2-A89C-00104B62BDDA" > TYPE="application/x-oleobject" > WIDTH="100%" HEIGHT="300" ID="Chart1" > CODEBASE=/download/CfxIEAx.cab#Version=5,5,10,2 > > > <PARAM NAME="LICENSE" VALUE="/license/CfxIE.lic"> > <PARAM NAME="DATAPATH" VALUE="/cfxtemp/CFT0219_145727287.chw"> > </OBJECT> > > </P> > </body> > </html> > > Thanks > Ian Dalton > >
Software FX Posted February 20, 2003 Report Posted February 20, 2003 Oops ! I realize I made a mistake, instead of: www.foo.com/folder/mypage/cfxtemp/CFT0219_145727287.chw I should have said: www.foo.com/cfxtemp/CFT0219_145727287.chw -- FP Software FX, Inc.
User (Legacy) Posted February 20, 2003 Author Report Posted February 20, 2003 I attached the chw file you asked for. I was able to download the file. The object that got downloaded to my machine was "Chart FX Internet Control Date = 11/25/2002 Version = 5,5,10,2". I also attached the CfxSrv.ini. Thanks for your help Ian Dalton "Ian Dalton" <idalton@dlbabson.com> wrote in message news:ur7o#TF2CHA.1312@webserver1.softwarefx.com... > We were on version 4,5,18,1 and we just put the patch on our server to get > up to 5,5,10,2 and once that got downloaded to a clients desktop the graphs > stopped working. listed below is my asp code that worked in the previous > version of Chart FX, but doesn't work with 5.5. It looks like the new > version is bring back a dummy line chart because the data is nothing like > what I am looking for plus it's bringing back 2 lines where I had only one > line in the previous version and I ran the sql in the background to make > sure it wasn't that end of things and it wasn't. > > Any help would be appreciated. > > ASP Code: > > <!-- #include file="../../Include/CfxIE.inc" --> > <html> > <head> > </head> > <body> > <% > Dim SPobj,Rs,Chart,sSQL,sCusip,RealCusip,iPosition > > RealCusip = Request.QueryString("sCusip") > > sSQL = "FinDatGetBond52Wk '" & RealCusip & "'" > > Set SPobj = Server.CreateObject("DLBSystem.clsDBFunctions") > Call SPobj.GetRS(CStr(sSQL), Rs, CLng(180),"CorpSec","Connection") > > Set Chart = Server.CreateObject("ChartFX.WebServer") > Chart.RgbBk = RGB(255,255,255) > Chart.Chart3D = False > Chart.Gallery = LINES > Chart.AxesStyle = CAS_FLATFRAME > Chart.Title(CHART_TOPTIT) = "Trailing Weekly Price History For " & RealCusip > & "" > Chart.AdoResultset Rs > 'Chart.SerLegBox = False > Chart.OpenDataEx COD_COLORS, 2, 0 > Chart.Color(0) = RGB(0,0,255) > Chart.CloseData COD_COLORS > Chart.Fonts(CHART_TOPFT) = CF_UNDERLINE > Chart.Axis(AXIS_Y).Decimals = 2 > Chart.Axis(AXIS_Y).ForceZero = False > Chart.RecalcScale > 'Chart.Series(0).MarkerSize = 2 > > Chart.Toolbar = True > Chart.DataEditor = True > Chart.AllowDrag = False > Chart.AllowEdit = False > Chart.Grid = 1 'Show the horizontal lines > > if Chart.Axis(AXIS_Y).Min = 0 then > else > Chart.Axis(AXIS_Y).Min = Chart.Axis(AXIS_Y).Min - 5 > end if > Chart.Axis(AXIS_Y).Max = Chart.Axis(AXIS_Y).Max + 5 > Chart.Axis(AXIS_Y).AdjustScale > %> > <%=Chart.GetHtmlTag("100%","300")%> > </P> > > </body> > </html> > > Also listed below is the source code of the graph page: > > <html> > <head> > </head> > <body> > <OBJECT CLASSID="CLSID:21F49842-BFA9-11d2-A89C-00104B62BDDA" > TYPE="application/x-oleobject" > WIDTH="100%" HEIGHT="300" ID="Chart1" > CODEBASE=/download/CfxIEAx.cab#Version=5,5,10,2 > > > <PARAM NAME="LICENSE" VALUE="/license/CfxIE.lic"> > <PARAM NAME="DATAPATH" VALUE="/cfxtemp/CFT0219_145727287.chw"> > </OBJECT> > > </P> > </body> > </html> > > Thanks > Ian Dalton > >
Software FX Posted February 25, 2003 Report Posted February 25, 2003 The attached chart file contains two series with the data as displayed in the data editor. So the problem is not in the client component reading the file, the file was generated this way by the server component. Is the data shown incorrect ? Other settings seem OK like colors, fonts, etc. It looks like the problem is only with the data. Please check the file version of CFX4DATA.DLL in your server. -- FP Software FX, Inc.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.