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
