session in asp&informix

[parames]

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&quot
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&quot = RS("designation&quot
if session("design&quot = "admin"
response.redirect "admin.asp"
else
response.redirect "user.asp"
end if
end if

if the RS("designation&quot 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&quot = "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

 

[culshaja]

Is the filed a CHAR. If so hten you will need to trim it to get rid of the padding. Access text fileds are equivelant to VARCHAR so you don't usually have any padding.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305