phlk

Members
  • Content count

    6
  • Joined

  • Last visited

About phlk

  • Rank
    Forum Newbie
  1. Date format

    Hi and thanks for getting back to me. That is really weird! I don't see how that could happen... when I run my SQL in e.g. Toad I see the exact data stored in DB and the data is stored like this: 21-06-2008 but that will be presented in charts x-axis like this 06/21/2008. How would the DB be formatting anything? Kind regards Peter
  2. Date format

    Hi, Data in database is stored like this: dd-mm-yyyy. but x-axis labels show mm/dd/yyyy. Why, and is there anyway to change that? Kind regards Peter Halkier
  3. ASP Class

    Hi, okay then. Thanks very much for the answer. Kindest regards Peter
  4. ASP Class

    Hi, I just have a simple (newbie) question. Am I able to use the ASP Class method with FWidgets (FMaps, FPowerCharts)? I am using the FusionCharts ASP Class as described in FusionCharts doc. under "Guide for Web developers" and it works fine. We have just bought enterprise licence for all products and I am hoping that we can just use same "technique" regardless... Kindest regards Peter
  5. Hi all, I would really really appreciate some help! Below code works and data is fetched from DB and presented using line.swf I have used these files DBConn.asp, FusionCharts_Gen.asp, FusionCharts.asp, Default.asp, PieData.asp to make it work. As you see I have changed PieData.asp a bit to suit my needs. Now I need to use the multi series line 2d chart in order to present some more data. How is that done??? Could someone please give an example of how below code would have to be modified... Please don't refer to the blueprints because they don't really help me much... I am not expert here (suprise! :w00t:) so please bear with me. Thanks very much to anyone taking the time to look into this for me. Kindest regards Peter ' Define chart attributes strParam="caption=HbA1c;subCaption=By Visit; xAxisName=Visit; yAxisName=HbA1c %; canvasRightMargin=20; canvasPadding=20; showValues=1; adjustDiv=0; numDivLines=5; yAxisMinValue=4; yAxisMaxValue=16; showBorder=0; showLabels=1; labelDisplay=Rotate; slantLabels=1; palette=3" 'Set chart attributes Call FC.setChartParams(strParam) ' Fetch all records usins SQL Query ' Store chart data values in 'total' column/field and category names in 'FactoryName' dim strQuery strQuery = "SELECT G.PT, G.CPEVENT, G.LVALUE FROM NN304_3511$CURRENT.GLUCLATE G Where LPARM_CODE = 'HBA1C_BLOOD' AND PT = '200001'" Dim oRs 'Create the recordset to retrieve data Set oRs = Server.CreateObject("ADODB.Recordset") Set oRs = oConn.Execute(strQuery) 'Pass the SQL Query result to the FusionCharts ASP Class function 'along with field/column names that are storing chart values and corresponding category names 'to set chart data from database If Not oRs.bof Then Call FC.addDataFromDatabase(oRs, "LVALUE", "CPEVENT", "", "") End If oRs.Close set oRs=Nothing 'Set Proper output content-type Response.ContentType= "text/xml" 'Just write out the XML data 'NOTE THAT THIS PAGE DOESN'T CONTAIN ANY HTML TAG, WHATSOEVER Response.Write(FC.getXML())