Problems Using Session (help)

[scubaman]

Hello,

I'm using the code to check if the user was subscribe into DB... so
he redirect if correct... if no.... go to other page...

My problem is... how routine I need put into the file...
conteudo.asp... to check if the session it's true if not.... redirect to file acessar.asp

Please help me...

'SELECT QUE BUSCA NO BANCO O NOME E A SENHA DO USUARIO
sqltemp="select * from acesso where usu = '" & nome & "'" & "and pass = '"&senha& "'"
set busca=session("banco&quot.execute(sqltemp)

'check if found
if busca.eof then
set busca = Nothing
response.redirect "Ace_neg.htm"
else
session("nivel&quot = busca("nivel&quot
set busca = Nothing
response.redirect "conteudo.asp"
end if %>

Thanks
Luciano

 

[ResolutionsNET]

Hey,

Without any more information are you sure that this line is correct

set busca=session("banco&quot.execute(sqltemp)

I would have had something like
set busca=objConn.execute(sqltemp)

where objConn is the ADODB.Connection object