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!!

Howdy, H! I believe what you want is known as an EXACT SEARCH. Here's a copy/paste of some old FM info I saved...

http://www.filemaker.com/ti/104829.html

Exact Match Finds in Custom Web Publishing

------------------------------------------------------------------------

To perform an exact match find (for example, find Joe Smith but not Joe Smithson) using CDML, use the following pair of tags in your form:

In this example the search field is "Name":

<input type=

Absolutely perfect!!!

I stared at the description of the == in the documentation and thought there was something there for me, but I was unable to put it all together. It works exactly as I had hoped now.

Thanks very much and take care.

Mike Tiehen, VEI