i made this script up it dosent work. what i want it to do is go to the database and see if anything is enteredinto the geog filed if their is then go to a particular page if not the do the next and so on untill all are done then if nothing in continues on to the last part.<BR><BR><BR>&#060;% <BR> email=Trim(request.QueryString("email")) <BR> txtpassword=Trim(request.QueryString("txtpassword" )) <BR> <BR><BR> sql="SELECT * FROM users WHERE email=&#039;"&email&"&#039; AND txtpassword=&#039;"&txtpassword&"&#039;" <BR> <BR> set db=Server.CreateObject("ADODB.Connection") <BR> db.Open"dbtest" <BR> set rs=Server.CreateObject("ADODB.RECORDSET") <BR> rs.Open sql, db, 3, 3 <BR> id=(rs.Fields("id")) <BR> geog=(rs.Fields("geog")) <BR><BR><BR> if not rs.EOF then <BR> &#039; Die Login-Informationen sind korrekt. <BR>If geog = 1 then<BR>Response.Redirect "1.htm"<BR>else <BR>if geog = 2 then<BR>Response.Redirect "2.htm"<BR>else <BR>if geog = 3 then<BR>Response.Redirect "3.htm"<BR>else <BR>Response.Write("login=ok&") <BR> Response.Write("_level0.idnumber="&id) <BR> else <BR> &#039; Die Login-Informationen sind falsch. <BR> Response.Write("login=failed") <BR> end if <BR>end if<BR>end if <BR>end if<BR>