Test that 20 character limit with the = and see if it still holds it might
not.
Also make sure FMP does not still let them in if there is no password but
you can prevent that by trapping for is missing before you allow the search.
Dan
--
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: Thu, 20 Mar 2003 00:52:12 +0000
> To: [EMAIL PROTECTED]
> Subject: Re: Witango-Talk: Login authentication issues
>
> Dan
>
>
> Thanks for that info
>
> I have found that a search prefixed by = in the TAF works the same as an ==
> search in Filemaker. == is Field Content Match and = is Exact Match - whatever
> they mean
>
> Leaving the system as it is will potentially cause problems if there is a
> 20-character limit. I could assume the passwords will always be different and
> key on password _and_ username on a search
>
> But it's not ideal in any way...
>
>
>> 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
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
