sessions in asp & informix

hi.. my codes about session is not working.. here's the code : sql = "select * from user where username = '" & (username) & "'" sql = sql & " and password = '" & (password) & "'" Set RS1 = Server.CreateObject("ADODB.Connection") RS1.open "DSN=test;UID=informix;PWD=informix" Set RS = RS1.Execute(sql) If RS.BOF And RS.EOF Then Response.Redirect "loginfail.asp" Else session("design") = RS("designation") if session("design") = "admin" response.redirect "admin.asp" else response.redirect "user.asp" end if end if if the RS("designation") value is admin.. it still go to the user.asp and not to admin.asp.. and i've tried this without using sessions, like if RS("designation") = "admin" ... but, it still doesn't work.. but, it works if i use microsoft access database.. but why cannot in informix.. please help.. thanks rgds, parames.s _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com