<% @Language="VbScript" %> <% dim conn dim strconn dim Gamers dim strsql dim strID dim latname dim firstname dim dept dim id dim strmsg dim count Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\nsenthil\db\mydb.mdb")) set rs = conn.execute("select eid,mid,fname,lname,title from orgtable") %>

orgchartGenerator9


Here is a demo of the applet where the chart data is generated dynamically from the server. This example illustrates the use of a new param SQL_OUTPUT_DATA. The value of this param is set to "yes". The ASP code used for this example is given here. The data is extracted from an Access database table called orgtable with the following data:
eid
mid
lname
fname
title
1 0 'Senthilnathan' 'Nalla' 'President and CEO'
2 1 'Morocco' 'Doug' 'Sales asia Pacifc'
3 1 'Mandarin' 'Tom' 'sales Americas'
4 1 'Bucharest' 'Mike' 'Sales australia'
5 2 'Last52' 'First52' 'Title52'
6 2 'Last62' 'First62' 'Title62'
7 4 'Last74' 'First74' 'Title74'
The dynamically generated chartdata param can be seen here. The data format is explained here.
To handle a bug in IE3.0

;<%= rs.fields("mid") %>; <%= rs.fields("fname") %> <%= rs.fields("lname") %>; <%= rs.fields("title") %>;0;0;ffcc66;emp1.html| <% rs.movenext loop conn.close set conn = nothing %> ">
To handle a bug in IE3.0


Back | Home | Nalla Senthilnathan