Hi all,

Yesterday i started on redesigning our knowledge-base, I decided to build a new base on a existing Dbase because it allready was up and running and in the process filled with all kinds of stuff.

Imagine my confusion when i build half the base and when i try to login, it fails.
Well, it didn't fail, i passed through the login and restrict access and then the confusion starts.
I always draw my member info inside the pages through a query having the uniqueID filtered by the login-session. This time the UniqueID is called mwID and consists of Usernames, in my case GALEN012.
So i set out as usual, welcome user... and that errors, it brings up EOF or BOF.

My question for all of you is, can UDev handle this kind of uniqueID and why does it fail ? I did the same thing on all my login routines and they work, but this one doesn't.
I tried adding a new UniqueID that returns the name of the person with UniqueID 1, where i log in with my account which is uniqueID 11 !

Here you can see how the Dbase is setup:

dennisvg.homeip.net/FIS/medewerkers.gif - the design view of medewerkers (employees) table.
dennisvg.homeip.net/FIS/kennis_relaties.gif - a image of all tables and relations

here you can try logging in yourself, use account GALEN003 user and pass are same, all CAPS.
dennisvg.homeip.net/FIS/index.asp

If anyone has a clue what's going on here, please tell me what is wrong in the Dbase.
I'm convinced it is the Dbase, but not sure what about it.
Please help, the people who helped create this don't know what's wrong either and the persons who designed the Dbase and handcoded pages are no longer working for us or our external offices, they've vanished.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services

Edited by - djvgalen on 06 Mar 2002 18:33:33

fixed.

I need someone who sometimes yells at me:

USE THE PROPER SESSION NAME !!!
duh, i'm stupid.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services