From the browser to the database relationship:
Browser
MSChart Control
JavaScript (Client-Side)
ASP (Server-Side Vbscript)
ADO
ODBC
DBMS
==================
The key is to assign contents within the RS to Client-Side JavaScript.
Source Code:
==================
<% @ Language = "VBScript"%>
<%
DIM OCONN
DIM ORS
DIM Curdir
DIM INDEX
DIM SQLSTRING
Sqlstring = "SELECT FIELD from Table"
'Create Ado Connection Component to Connect
'with sample data
Set Oconn = Server.createObject ("AdoDb.Connection")
Oconn.open "DSN = localserver; server = (local); UID = sa; pwd =; database = pubs
SET ORS = Oconn.execute (Sqlstring)
%>
<% Response.write "
Sub window_onload ()
DIM A
A = array (<%
Do While (Not Ors.eof)%>
<% = Int (ORS (0))%>, <% ors.movenext
Loop
%> 0)
Mschart1.ChartType = 1
Mschart1.ChartData = a
End Sub
<% Response.write "->"%>
script>
<%
Ors.close
Oconn.close
%>
Document Title Title>
HEAD>