Login's from a Database

[Thomas]

Hello,
what I mean is: I have user login names and their passwords in a table. I want to check the typed name and pwd against the database before the App shows anything meaningfull. Can anybody give me a hint ? The Login before Frame example is ways to simple.
TIA, Thomas.

[Mike Grigsby]

That's the example I used to build my login. Do you mean you don't want them to see any menu stuff before they're logged in? I simply turned off the menu until they log in by  physically requiring their user level to be above 50. So the Menu extension in my PageHeaderTag proc has the condition: p_web.GetSessionValue('ULVL') >= 50

No one is given the condition above 50 until they are verified or manually changed or set up to that level.

So I use the ProcessUser proc to determine who goes where, by putting this info in the XHtml 'head" AfterBody area. (I think this is the same as the login demo)

<script type="text/javascript">

function load1()
{
  window.location="ListRequisitions"
}

function load2()
{
  window.location="HomePage"
}

</script>

In my case they can view a list with no security level, or if they have a security level, they go to the HomePage, but there they can only see what I allow them to see based on the p_web.GetSessionValue('ULVL') >= 50 statement on each element of the page. Does that help?

[Thomas]

Hello Mike,
with your hint I could got it running with my User/PWD database.
Thnx, Thomas.