| Author |
List all employees
|
|
| JP SIngh 2004-10-27, 3:55 pm |
| 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] 2004-10-27, 3:55 pm |
| 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 2004-10-27, 3:55 pm |
| The database is Access 2000.
thanks
"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:OlhmGzCvEHA.2624@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:
>
> --
> 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] 2004-10-27, 3:55 pm |
| 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:[color=darkred]
> The database is Access 2000.
>
> thanks
>
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:OlhmGzCvEHA.2624@TK2MSFTNGP11.phx.gbl...
--
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 2004-10-27, 3:55 pm |
| "JP SIngh" <none@none.com> wrote in message
news:OEQmHwCvEHA.3728@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?thr...FTNGP12.phx.gbl
| |
|
|
| Ben Strackany 2004-10-27, 8:55 pm |
| 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" <none@none.com> wrote in message
news:OEQmHwCvEHA.3728@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 2004-10-28, 8:55 am |
| HI Chris
Thanks for pointing this out. We are not fimiliar with XML hence looking for
an ASP version of the code.
"Chris Hohmann" <nospam@thankyou.com> wrote in message
news:uo1UjAFvEHA.3200@TK2MSFTNGP14.phx.gbl...
> "Chris Hohmann" <nospam@thankyou.com> wrote in message
> news:ug2L%237EvEHA.200@TK2MSFTNGP11.phx.gbl...
> table
much[color=darkred]
>
http://groups.google.com/groups?thr...FTNGP12.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?sel...FTNGP12.phx.gbl
>
>
|
|
|
|