how can use authenticate on the default.asp page ?

I have use following coding in the default.asp page, it is main page of program, I want to use authentication on this page.
when user access default.asp page it check userid is available on the
table. if user available it work according on this coding otherwise
it should redirect to sign.asp.

if userid not found in table and then page redirect to signin.asp page.

after signin, user available on table it working main page coding

default.asp is the main page where autenticate are check.


when user again access this page
but it does not work on this coding
it again and again move to sign.asp page why ?

what logic (coding) I use for the maing page authentication (default.asp)?



for the NT authentication.


<%
name = Request.ServerVariables("logon_user")
user = mid(name, 9, (len(name)-8))

// connection

ssql="select userid from authen where userid= '" & user & "'"

set rs=cn.Execute(ssql)

if Not rs.EOF Then

// page main program coding her ie. default.asp

Else
    Response.Redirect("http://dcilweb/sas/signin.asp")
End If
%>




Mateen

I am guessing that the default page has not been given a user name at the point where the user enters the page. Try setting a cookie on the user's machine that contains the user_name so that you may request that value when the page opens the next time they visit. If it is an internal machine you might be able to use Windows authentication.

thanks.