I now see this error in the data file.
Microsoft OLE DB Provider for SQL Server error '80040e14'
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
/DynamicWebCharts/Data/Stats_M_chart_data1.asp, line 13
change the recordset code in the /DynamicWebCharts/Data/Stats_M_chart_data1.asp file from:
WADWCdboRegisteredUser_cmd.CommandText = "SELECT LEFT(DATENAME(month, dateadded), 3)+' '+LTRIM(YEAR(dateadded)) AS XLABEL, COUNT(ID) AS YVALUE FROM dbo.RegisteredUser WHERE dateadded >= '1/1/2009' AND dateadded <= '3/1/2012' GROUP BY LEFT(DATENAME(month, dateadded), 3)+' '+LTRIM(YEAR(dateadded)), DATEPART(year, dateadded), DATEPART(month, dateadded) ORDER BY DATEPART(year, dateadded) ASC, DATEPART(month, dateadded) ASC, DATEPART(year, dateadded) ASC, DATEPART(month, dateadded) ASC"
to:
WADWCdboRegisteredUser_cmd.CommandText = "SELECT LEFT(DATENAME(month, dateadded), 3)+' '+LTRIM(YEAR(dateadded)) AS XLABEL, COUNT(ID) AS YVALUE FROM dbo.RegisteredUser WHERE dateadded >= '1/1/2009' AND dateadded <= '3/1/2012' GROUP BY LEFT(DATENAME(month, dateadded), 3)+' '+LTRIM(YEAR(dateadded)), DATEPART(year, dateadded), DATEPART(month, dateadded) ORDER BY DATEPART(year, dateadded) ASC, DATEPART(month, dateadded) ASC"
