Help..I worked a whole day on this problem and I'm about to give up...
I have a database with 7500 records. There is a username (actually an e-mail address) and password fields in all records.
This a database with a custom interface for the web.
My Problem: I need to find a record based on MATCHING the two fields. (email AND password)
If I enter correct info in only one field, and leave the other field blank, the record is still returned. (Bad...)
If I enter correct info in one field, and incorrect info in the other, I get the error page. (Good...)
Here is the html source for the page (I stripped out the table junk to better see the code)
<form action="FMPro" method="post">
<input type="hidden" name="-DB" value="mercy2.fp5">
<input type="hidden" name="-lop" value="and">
<input type="hidden" name="-format" value="login_results.html">
<input type="hidden" name="-error" value="search_error.htm">
Username: <input type=text name="email" value="" size=30>
Password:<input type=password name="password" value="" size=30>
<input type="submit" name="-Find" value="Login">
</form>
The documentation for Filemaker is really lacking when it comes to explaining the web connection stuff. I suspect I need an IF Then statement, but I'm not smart enough to figure that out.
Thanks for any help.
Mike Tiehen
VEI
p.s. when I get this working...I still have to deal with that dang @ in the e-mail address!!
