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 !'
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
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])

Reply to this topic