<% @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. The value of the param SQL_OUTPUT_DATA 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:
...
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