List all employees

[JP SIngh]

Hi All

I have a table which stores the employee details. The format of the table is
below

EmpNo _ Integer
FirstName - Text
Lastname - Text
ManagerNo - Integer

What I would like to do is to display in a tree structure all the employees
reporting to a particular employee.

For examples I might have 4 people reporting to me and also might have other
employees reporting to those who report to me. Something like the structure
below.

Employee A
Employee B
Employee B.1
Employee B.2
Employee C
Employee D
Employee D.1
Employee D.2
Employee D.2.2
Employee E

Anyone has any idea who this can be done. Some sample code will be much
appreciated
thanks

Jas

 

[Bob Barrows [MVP]]

If you are using SQL Server, look up "Expanding Hierarchies" in BOL. If some
other database, post back and let us know which one.

Bob Barrows

 

[JP SIngh]

The database is Access 2000.

thanks

If you are using SQL Server, look up "Expanding Hierarchies" in BOL. If some
other database, post back and let us know which one.

Bob Barrows


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

 

[Bob Barrows [MVP]]

I don't have time to thoroughly deal with this question right now (I'm at
work), so I suggest that you spend some time using Google to research using
ASP to expand hierarchical data stored in an Access table using a
self-referencing relationship into tree views. There, that should be enough
keywords to keep you busy until tonight. Post back if you have specific
questions and I will be able to address them then.

Bob Barrows

 

[Chris Hohmann]

Hi All

I have a table which stores the employee details. The format of the table is
below

EmpNo _ Integer
FirstName - Text
Lastname - Text
ManagerNo - Integer

What I would like to do is to display in a tree structure all the employees
reporting to a particular employee.

For examples I might have 4 people reporting to me and also might have other
employees reporting to those who report to me. Something like the structure
below.

Employee A
Employee B
Employee B.1
Employee B.2
Employee C
Employee D
Employee D.1
Employee D.2
Employee D.2.2
Employee E

Anyone has any idea who this can be done. Some sample code will be much
appreciated
thanks

http://groups.google.com/[email protected]

 

[Chris Hohmann]

table

http://groups.google.com/[email protected]

Sorry, forgot the part where you said you were using Access 2000. Here's a
database agnostic version:
http://groups.google.com/[email protected]

 

[Ben Strackany]

Try pulling all the data back & using a recursive function to display it
within <ul>, kinda like

rs = getdata()
empid = request("employeeid")

showgrunts rs, empid

sub showgrunts(rs, id)
var rsTmp
set rsTmp = rs.clone
response.write "<ul>"
rsTmp.filter = "ManagerNo = " & id
' list employees
while not rs.eof
response.write "<li>" & rs("FirstName") & " " & rs("LastName")
' list this guys grunts
showgrunts rs, rs("EmpNo")
response.write "</li>"
rs.movenext
wend
response.write "</ul>"
set rsTmp = nothing
end sub

I'm assuming you dont have bajillions of employees.

 

[JP SIngh]

HI Chris

Thanks for pointing this out. We are not fimiliar with XML hence looking for
an ASP version of the code.