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 wrote:

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

--
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.

[JP SIngh]

The database is Access 2000.

thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:Ol**************@TK2MSFTNGP11.phx.gbl...

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 wrote:

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

--
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
JP SIngh wrote:

The database is Access 2000.

thanks

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:Ol**************@TK2MSFTNGP11.phx.gbl...

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 wrote:

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

--
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.

--
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.

[Chris Hohmann]

"JP SIngh" <no**@none.com> wrote in message
news:OE**************@TK2MSFTNGP12.phx.gbl...

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/groups?thre...TNGP12.phx.gbl

[Chris Hohmann]

"Chris Hohmann" <no****@thankyou.com> wrote in message
news:ug***************@TK2MSFTNGP11.phx.gbl...

"JP SIngh" <no**@none.com> wrote in message
news:OE**************@TK2MSFTNGP12.phx.gbl...

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/groups?thre...TNGP12.phx.gbl

Sorry, forgot the part where you said you were using Access 2000. Here's a
database agnostic version:
http://groups.google.com/groups?selm...TNGP12.phx.gbl

[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.

--
Ben Strackany
www.developmentnow.com
"JP SIngh" <no**@none.com> wrote in message
news:OE**************@TK2MSFTNGP12.phx.gbl...

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

[JP SIngh]

HI Chris

Thanks for pointing this out. We are not fimiliar with XML hence looking for
an ASP version of the code.
"Chris Hohmann" <no****@thankyou.com> wrote in message
news:uo**************@TK2MSFTNGP14.phx.gbl...

"Chris Hohmann" <no****@thankyou.com> wrote in message
news:ug***************@TK2MSFTNGP11.phx.gbl...

"JP SIngh" <no**@none.com> wrote in message
news:OE**************@TK2MSFTNGP12.phx.gbl...

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/groups?thre...TNGP12.phx.gbl
Sorry, forgot the part where you said you were using Access 2000. Here's a
database agnostic version:
http://groups.google.com/groups?selm...TNGP12.phx.gbl