Multi-Series With Asp Class

[200West]

Hi, I'm using ASP class and trying to display data in a multiseries chart - MSColumnLine3D.

 

I'm having trouble getting the data to be spread across the categories. I'm trying to use the addCategoryFromDatabase and addDatasetsFromDatabase functions. Here is the code snippet. Any help would be appreciated.

dim strQuery2

strQuery2 = "Select WeekDate, SUM(Value) as Shipments From Forecast Where ID='2' and WeekDate >= '2012-03-14' and TypeID = '7' Group By WeekDate"

 

 

' Add category names

 

dim recordset

 

recordset = Server.CreateObject("ADODB.Recordset")

 

Set recordset = oConn.Execute(strQuery2)

 

Call FC.addCategoryFromDatabase(recordset, "WeekDate")

 

 

 

' Add a new dataset with dataset parameters

 

dim oRS

 

Set oRS = Server.CreateObject("ADODB.Recordset")

 

oRS.open strQuery2,oConn,1,1,1

 

Call FC.addDatasetsFromDatabase(oRs, "WeekDate","Shipments","","")

 

 

[Sanjukta]

Hi,

 

Please note that the code is purely classic ASP code, so it should be also working on VB script.

 

However, could you please send us the scaled down version of the code so that we might test it?

 

Awaiting your reply.

[200West]

Hi,

 

Please note that the code is purely classic ASP code, so it should be also working on VB script.

 

However, could you please send us the scaled down version of the code so that we might test it?

 

Awaiting your reply.

 

Thank you for your reply. The page is rendering a chart and the data from the db appears in the chart but it's all showing up on the same day so I've got something wrong with my categories I think. I've attached the classic ASP page. Is this what you meant by a scaled down version? Thanks again.

[Guest Sumedh]

Hi,

 

I am unable to view the code. Can you please re-send the code?

 

Awaiting your response.