ASP Login Help

lyonsf

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.

danielneri

so you need like a different group script?

danielneri

http://vt.rovno.info/

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

design1

I am not sure I follow you entirely, but you might want to try something like this, with your sql statement:

sql = "SELECT * from tablename where Subject_Area = 'x'{@}