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