I have a database for my clients that I want to require two fields for them to sign in with (name and password fields). I would like to avoid using the Web Security Database for configuration reasons.

What I have now is not working properly. All the client has to do now is fill in one of the fields to gain entry to the database. How do I create a login page that requires both fields to be filled in before allowing entry into the database?

Thanks in advance for you help

A couple of ways exist. These have been discussed recently in these forums. In brief, use the "-op" parameter:

<input type="hidden" name="-Op" value="eq">

<input type="text" name="name">

<input type="hidden" name="-Op" value="eq">

<input type="text" name="password">

---

The other way is to use Javascript to pre-validate the entries.

All the best.

Garry

I have the -op parameter in place right now and it does not work the way I would like. If someone fills in the name field and not the password field and then presses submit, they get in. The same will happen if they fill in the password field and not the name field. Can point me to where I can find information on the "Javascript to pre-validate" ?

Thank you - Sam

The CDML method will work. Check this thread, it has some links to worthwhile resources:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB22&Number=21417&Forum=UBB22&Words=login&Match=Entire%20Phrase&Searchpage=1&Limit=25&Old=allposts&Main=21417&Search=true#Post21417

Good Luck.

Garry

You can do it in CDML and FM also, e.g. to use calc field with Name & Password and compare that...

How you will protect the databases against hacking?