I have a database where users log in with a username and their email address. The only problem is the "@" in the email address. When I perform a find in the database, the "@" is a special character and filemaker will not find any records. For example: if the email address is stored in the database as [email protected], I can do a find on "test" and I am able to find and display the record, but a find on "[email protected]" gives me a "format file not found error". How can I get around this frustration? Argh!

Just guessing - did you tried the URL encodings?

This is the code I am using:

<form action="http://fmserver.com/FMPro" method="POST">

<input type="hidden" name="-db" value="customers"><input type="hidden" name="-format" value="portfolio.html"><input type="hidden" name="-error" value="badpass.html"><input type="hidden" name="-lay" value="ENTRY"><br>

Please enter your Customer Number<BR>

<input type="text" name="customer number" size="24">

Please enter your email address<BR>

<input type="text" name="email" size="24">

<input type="submit" value="Search" name="-Find">

I've found, that FM does not like to search for email address containing the '@' character.

Try to insert the = or == before the search.

Put speech marks around the email address

ie "[email protected]"

This works on my site

Simon Pennington