close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Charts Fail with Path image

Thread began 4/13/2010 2:27 pm by sue.hawkins403581 | Last modified 4/14/2010 2:27 pm by Jason Byrnes | 1789 views | 8 replies |

sue.hawkins403581

Charts Fail with Path image

I am trying to create a simple pie chart with dynamic data from a SQL server database. I have IIS 6, configured the site to use ASP Vbscript and tested the database connection using simple dynamic text statement. This is a link to a test page:

FASTU.asp

As you can see the database is responding to the simple query with a table of values. The pie chart I want should show the portion of students from each college, such as 20% CLAS, 40% COE and 40% CAP, for an example.

I used the most simple approach I could think of, and I still just get the path to the dataparser.asp! These are the settings I used in the wizard:

Chart Tab:
Only edit to default values on this tab is the change to Type: Pie

Data Tab:
Edits to default values are --
Choose dynamic
Choose connection, data source from the drop-downs
X Label: set to "College" from the drop-down
Group by: set to Value
Y Value: set to "unique" (a unique integer identifier) from the drop-down
Calculation set to Count

No other edits are made in the wizard.

I have installed, uninstalled, reinstalled, deleted WinCache.dat.

Can you help me to understand what I need to do?

Thanks!

Sue

Sign in to reply to this post

Jason ByrnesWebAssist

if I browse directly to the data file:
FASTU_data1.asp


I see the following error:
Active Server Pages error 'ASP 0131'

Disallowed Parent Path

/DynamicWebCharts/Data/FASTU_data1.asp, line 2

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



thin]\s means your host has configured the asp server not to allow document relitive paths.

to work around this, edit you Dreamweaver site, On the Local Info tab, set the "Create Links Relative To" to Site instead of Document, then recreate your chart.

Sign in to reply to this post

sue.hawkins403581

Charts Fail with Path image

Hello Jason,

I did set links relative to Site Root at the local info entry. It was set to document, and I changed it when I saw a similar problem in the forums. Is there something I should do at the server level? I am admin for this web server ...

Thanks,

Sue

Sign in to reply to this post

Jason ByrnesWebAssist

you could enable parent paths in the IIS Settings:
226474

Sign in to reply to this post

sue.hawkins403581

Charts Fail with Path image

Hi Jason,

Thanks for the pointers.

1) I enabled the parent paths in IIS
2) Set Dreamweaver to use relative to document
3) Re-created the webassist chart

It still doesn't show a chart. Am I still doing it wrong?

Thank you so much!

Sue

Sign in to reply to this post

Jason ByrnesWebAssist

the data page gives a new error:
FASTU_data1.asp

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'unique'.

/DynamicWebCharts/Data/FASTU_data1.asp, line 12


can you send a copy of your DynamicWebCharts/Data/FASTU_data1.asp page so i can examine the code?

Sign in to reply to this post

sue.hawkins403581

Charts Fail with Path image

Hi Jason,

Not sure how to attach, here:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><!--#include file="../../Connections/GIS.asp" -->
<%
Dim WADWCdboIchart
Dim WADWCdboIchart_cmd
Dim WADWCdboIchart_numRows

Set WADWCdboIchart_cmd = Server.CreateObject ("ADODB.Command")
WADWCdboIchart_cmd.ActiveConnection = MM_GIS_STRING
WADWCdboIchart_cmd.CommandText = "SELECT logonCollege AS XLABEL, COUNT(unique) AS YVALUE FROM dbo.Ichart GROUP BY logonCollege"
WADWCdboIchart_cmd.Prepared = true

Set WADWCdboIchart = WADWCdboIchart_cmd.Execute
WADWCdboIchart_numRows = 0
%>
<%
Dim WADWCdboIchart__numRows
Dim WADWCdboIchart__index

WADWCdboIchart__numRows = -1
WADWCdboIchart__index = 0
WADWCdboIchart_numRows = WADWCdboIchart_numRows + WADWCdboIchart__numRows
%><?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE wa_dwc SYSTEM "wa_dwc.dtd">
<wa_dwc name="Clean" version="1.0">
<color_wheel name="SLATE">
<color><![CDATA[#2d2b2e]]></color>
<color><![CDATA[#3a32c4]]></color>
<color><![CDATA[#b0b6bd]]></color>
<color><![CDATA[#5456ef]]></color>
<color><![CDATA[#d8dcbf]]></color>
<color><![CDATA[#c0c3a9]]></color>
</color_wheel>
<title style=" font-size:16px; color:#2d2b2e; text-align:center;">
Chart%20Title
</title>
<background color="#ffffff" align="left" valign="top"/>
<innerbg startcolor="#e3e3e4" endcolor="#9ea3aa" direction="90"/>
<yaxis color="#767a7f" gridcolor="#888d93">
<labels size="11" fontcolor="#50516b" ></labels>
<legend size="12" color="#2d2b2e">
Y%20Axis%20Legend
</legend>
</yaxis>
<xaxis color="#767a7f" gridcolor="#888d93" offset="true">
<legend size="12" color="#2d2b2e">
X%20Axis%20Legend
</legend>
<labels size="11" fontcolor="#50516b" orientation="2">
</labels>
</xaxis>
<data>
<dataset style="{font-size:9px;color:#767a7f;}" size="9" width="2" color="#2d2b2e" label="Dataset%20Label" dotsize="5" opacity="80" abstraction="4" outline="#767a7f" linecolor="#767a7f" type="pie">
<%
While ((WADWCdboIchart__numRows <> 0) AND (NOT WADWCdboIchart.EOF))
%><point >
<label><%=(WADWCdboIchart.Fields.Item("XLABEL").Value)%></label>
<value><%=(WADWCdboIchart.Fields.Item("YVALUE").Value)%></value>
</point><%
WADWCdboIchart__index=WADWCdboIchart__index+1
WADWCdboIchart__numRows=WADWCdboIchart__numRows-1
WADWCdboIchart.MoveNext()
Wend
%>
</dataset>
</data>
</wa_dwc>
<%
WADWCdboIchart.Close()
Set WADWCdboIchart = Nothing
%>

Thanks,

Sue

Sign in to reply to this post

sue.hawkins403581

Charts Fail with Path image

Hi Jason,

It works! I edited Count(unique) to Count ([unique]).

THANKS!!!

Sue

Sign in to reply to this post

Jason ByrnesWebAssist

yes, unique is an SQL Reserved word and should be avoided as a column name.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...