Hi there,



Our website has two parts, Part_A is for students(Requires student name 

and id to login. Name and id in sql server DB), Part_B is for the members

(Requires member name and password to login. Name and password in sql 

server DB). We now want to open one section(named Career) of the Part_B to 

the students. The students can go to the Career section of Part_B from 

Part_A where they get access but the students will not have further 

permission to view any other pages of Part_B. Any suggestions and codes 

will be appreciated.



Alan

> Hi there,

> 

> Our website has two parts, Part_A is for students(Requires student name 

> and id to login. Name and id in sql server DB), Part_B is for the members

> (Requires member name and password to login. Name and password in sql 

> server DB). We now want to open one section(named Career) of the Part_B 

to 

> the students. The students can go to the Career section of Part_B from 

> Part_A where they get access but the students will not have further 

> permission to view any other pages of Part_B. Any suggestions and codes 

> will be appreciated.





Hello, 



In your DB you'll have their name, ID#. Also put in another field

where you can flag them as members thus eliminating the second need for 

authentication.

ie a record would look like:



Kendra McDaon, 215552, myPass, Member



try this for page A: 



<%

Set objConn = Server.CreateObject("ADODB.Connection")

Set objRS = Server.CreateObject("ADODB.RecordSet")



ObjCon.open [your database connection]

objRS.open select NAME, IDNUM, PASSWD, STATUS from users



%>



Blurb about your page...

Password auth...



Match name entered with one in DB and set the status session variable.



'This saves the status of member/nonmember for the entire session that

'they are logged into the system, including across several pages.

'**********************************

Session("STATUS") = objRS("STATUS")

------------------

Then page B.



Career section.



<% if Session("STATUS") = "Member" %>   

Rest of page B

<%Else%>

Sorry, you do not have access to this page

<%End if%> 



etc...



Hopefully this helps

Sandra