Forums
This topic is locked
Before start of resultset....
Posted 14 Aug 2002 10:20:52
1
has voted
14 Aug 2002 10:20:52 Erwin Hendriks posted:
I've designed a page to show user data. Acces is restricted by username/password authentication.If I choose the menu-link to this page without logging in, I should be redirected. This does not happen. Instead, The page tries to build a recordgroup, which depens on being logged on, with the following error: servletexception: before start of resultset.
any suggestions? pleez help! I need to fic this today...
Replies
Replied 14 Aug 2002 10:38:04
14 Aug 2002 10:38:04 Iain Stewart replied:
create another field in your username/pasword database, access level and asign each log in account an access level say 1 for admin 3 for normal users.
Then set the restricted pages to access based on username password and access level and set a redirect for wrong access level this should work the way you want it.
Iain
head hurts, 'mental note to self, stop banging head !'
Then set the restricted pages to access based on username password and access level and set a redirect for wrong access level this should work the way you want it.
Iain
head hurts, 'mental note to self, stop banging head !'
Replied 14 Aug 2002 15:09:27
14 Aug 2002 15:09:27 Erwin Hendriks replied:
The problem remains the same when I restrict user-access with username/password/acceslevel validation....
Thanks anyway, more suggestions welcome
Thanks anyway, more suggestions welcome
Replied 14 Aug 2002 17:50:04
14 Aug 2002 17:50:04 aegis kleais replied:
Have you tried placing username and password into sessions and then placing code like:
<%
if (Session("username"
= "" or Session("password"
= ""
then
Response.Redirect("login.asp"
end if
%>
before the rest of the code?
Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])
<%
if (Session("username"



Response.Redirect("login.asp"

end if
%>
before the rest of the code?
Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])