I'm creating a website and its almost complete: (90% complete, 70% still to do
)
I have a login page to create that will use the details provided to pull some information from a db.
For example:
the db has 7 fields refering to a project that a section has in progress,
i need to provide the facility that would let bob from supply login and only see supplies projects and frank from developement login and only see the developement departments projects.
One of the fields in the db is called 'Subject_Area' and this will contain the section they work in.
Creating a login process i can do but i dont know how to say user 'x' can only see recordsets with 'Subject_Area' = 'x'
If someone could offer some assistance I would be very grateful.
lyonsf
BeginnerLink Clerk
Comments
that site has a nice script that has a folder to each user...you should be able to customize it a bit
try your hand at it...
if you need help, i can try i know some stuff bout asp
sql = "SELECT * from tablename where Subject_Area = 'x'{@}