You can quote the string you want to use for your search ("[EMAIL PROTECTED]" ). You might still run into the 1st 20 character problem if your logins are long.
On Wednesday, March 19, 2003, at 03:53 PM, Dan Stein wrote:
There are two problems with Filemaker you could be running into
1. for searching Filemaker ignores everything after 1st 20 characters and
also it does contains searches by default.
You might want to make a calculated field in FMP that is password and email
but strip the @ symbol from the email so
Logincheck= Substitute(email, "@", "") & "_" & password
You could even get rid of the "." the same way
Then you would be searching for the logincheck you would have to manipulate
the witango input to match.
What is happening it looks like is a Filemaker find name and name@ and [EMAIL PROTECTED] are all going to find the same thing in FMP.
You either need a logincheck calculation field in FMP to search on or you
need to make sure you have a full email address entered.
Easier to do the 1st than the latter.
-- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com
From: Nicholas Froome <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 19 Mar 2003 22:56:49 +0000 To: [EMAIL PROTECTED] Subject: Witango-Talk: Login authentication issues
I've built a Login system based on the one in the SAMS Tango book. It works
very nicely, but I've recently discovered a few strangenesses with it
If I have a username = [EMAIL PROTECTED] and password = password, I get a
successful Login using name & password - as well as with [EMAIL PROTECTED] &
password
Is this because the @ sign should be encoded? If so, what's the best way to do
this?
Or is it because Filemaker matches up to the @ sign and ignores text after
that?
Email addresses are stored in Filemaker 4.0 and I'm using Tango 3.6x
_____________________________________________________________________ ___
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
______________________________________________________________________ __
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
