Sign in to follow this  
200West

Multi-Series With Asp Class

Recommended Posts

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","","")

 

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
Guest Sumedh

Hi,

 

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

 

Awaiting your response.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this