DynamicWebCharts/Data/MainPage_dataparser1.asp?

[rbutcher435031]

Not sure why I get DynamicWebCharts/Data/MainPage_dataparser1.asp? when I attempt to get a dyname chart static charts seems to work? using dw3 with SQL back end.

[Jason Byrnes]

please post a link to your chart.

also a copy of the DynamicWebCharts/Data/MainPage_dataparser1.asp and the DynamicWebCharts/Data/MainPage_data1.asp pages would be helpful in a zip archive

[rbutcher435031]

Attached are the files

[rbutcher435031]

MainPage attached

[Jason Byrnes]

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
http://www.webassist.com/mywebassist/supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

[victor367017]

I am having the exact same problem.

The data can be displayed but I get the message /DynamicWebCharts/Data/Stats_M_chart_dataparser1.asp? after flash starts.

I am using CS 5.5. I am providing you the same files that you asked for in response to an earlier problem. In addition I have provide a copy of the ASP page that I am trying to put the dynamic chart as well as a text file with the url that is failing.

[Jason Byrnes]

visiting the page that creates the chart data:
/DynamicWebCharts/Data/Stats_M_chart_data1.asp


shows the following error message:
Active Server Pages error 'ASP 0131'

Disallowed Parent Path

/DynamicWebCharts/Data/Stats_M_chart_data1.asp, line 2

The Include file '../../Connections/pcuser.asp' cannot contain '..' to indicate the parent directory.



to correct the problem, edit your dreamweaver site definition, on the Local Info tab set the "Create Links relative to" option to Site. this will cause dreamweaver to use "include virtual" instead of "include file" when adding the connection to the chart page.

you will need to recreate the chart after making this change.

[victor367017]

I already had that in place so that is NOT the solution.

[Jason Byrnes]

on the /DynamicWebCharts/Data/Stats_M_chart_data1.asp file, try changing:

<!--#include virtual="../../Connections/pcuser.asp" -->


to:
<!--#include virtual="/Connections/pcuser.asp" -->

[victor367017]

Did that and I get the message

/DynamicWebCharts/Data/Stats_M_chart_dataparser1.asp?

[Jason Byrnes]

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"

[victor367017]

Thank you that worked. Now I will have to figure out how I duplicated the fields.

[Jason Byrnes]

glad to hear it is working.