I want to authenticate the intranet site by following coding.
But I could not success to authenticate the page with server.
Please check the condition
If user = “rs” then page will redirect.

I could not get value in rs and condition not working.
How I can get value in rs so that I check condition.

following coding give this error message
"
Response object, ASP 0185 (0x8002000E)
A default property was not found for the object.
/dcil/signin.asp "

Please help.
What problem in this coding. how I can solved it.


<%
name = Request.ServerVariables("logon_user")

user = mid(name, 9, (len(name)-8))

dim ssql
set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="Provider=SQLOLEDB.1;Integrate d Security=SSPI;Persist Security Info=False;Initial Catalog=dcil;Data Source=AUHTRIPSVR2"
cn.Open

ssql="select user_id from system order by user_id"

set rs=cn.Execute(ssql)

do while rs.eof=false

rs.movenext
loop

if user = "rs” then

Response.Redirect("trip.asp")

else

Response.Redirect("signin.asp")

end if


%>

You are not checking whether any of the records contain the user's name. You are also comparing the variable user to a hard coded string "rs" therefore the only time the code will work is when the name is "rs".

Assuming the database table 'system' has a field 'user' which contains the user's name here is what I would do:

You really need to think about how you are coding, this is a very simple problem that can be solved by using common sense.

The variable rs is a recordset which contains records, "rs" is a string that will always have a value of "rs" and unless you actually look for the row in your recordset instead of just looping through them all you will never find the correct row.

Hardly an ASP Pro Code question, more of a 'can someone teach me how to program' question.

Regards
Owain Williams

Why not just add a WHERE clause to your SQL, like this:

Thanks you for your help

Mateen