[FX.php List] Finding emails in Filemaker with PHP

[Joel Shapiro]

(attempting to stay under the radar...

If someone enters JohnSmith at gmail.com in FMP (client) and it's stored  
as Unicode, then trying to find johnsmith at gmail.com through PHP --  
whether before or after  strtolower() -- will fail.  No?

OK.  Over and out (?)

-Joel


On Sep 10, 2008, at 2:00 PM, Gjermund Gusland Thorsen wrote:

> Why?
>
> 2008/9/10 Joel Shapiro <jsfmp at earthlink.net>:
>> And on the FM end you'd probably have to do the same, using Lower 
>> () as an
>> auto-enter calc.
>>
>> OK, this thread's gone on long enough.  Over and out.
>>
>> -Joel
>>
>>
>> On Sep 10, 2008, at 1:41 PM, Gjermund Gusland Thorsen wrote:
>>
>>> Well that part of quality insurance is simple to do from the php  
>>> point
>>> of view there should be strtolower() in php?
>>>
>>> ggt
>>>
>>> 2008/9/10 Joel Shapiro <jsfmp at earthlink.net>:
>>>>
>>>> But one problem w/ setting an email field's index to unicode is  
>>>> that if
>>>> someone searches for JohnSmith at gmail.com, they won't find
>>>> johnsmith at gmail.com, right?
>>>>
>>>> -Joel
>>>>
>>>>
>>>> On Sep 10, 2008, at 8:57 AM, Gjermund Gusland Thorsen wrote:
>>>>
>>>>> The reason why it's clumsy to store emails in the a field that  
>>>>> has a
>>>>> language sorting is:
>>>>>
>>>>> Language indexes strips off everything outside of the  
>>>>> characters that
>>>>> makes up the language,
>>>>> for english that would be all characters [A-Z][a-z] on top of  
>>>>> it all
>>>>> A=a, so much for individual characters...
>>>>> @ is most likely turned into an IFS( inter field separator such as
>>>>> tab, newline and space ) when a language is used for indexing the
>>>>> field.
>>>>>
>>>>> Switching to Unicode instead of a language does turn off all this
>>>>> imaginary wordsplitting stuff and therefore indexes an email as 1
>>>>> entity.
>>>>>
>>>>> hth,
>>>>> ggt
>>>>>
>>>>> 2008/9/10 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>>>>>
>>>>>> I am sure you would all benefit from first making the fields  
>>>>>> correct,
>>>>>> then the tables, then the relationships, then the php/ScriptMaker
>>>>>> stuff.
>>>>>>
>>>>>> Doing the design right makes alot of scripting unnecessary.
>>>>>>
>>>>>> ggt
>>>>>>
>>>>>> 2008/9/10 Michael Layne <fx at 9degrees.com>:
>>>>>>>
>>>>>>> Here's what I did a few years ago because it was a bit  
>>>>>>> squirrelly
>>>>>>> (like
>>>>>>> you're finding out...)
>>>>>>> in PHP...
>>>>>>> $user = str_replace("@","",$_POST['email']);
>>>>>>> // BEGIN : here we're grabbing the record information
>>>>>>> $q = new FX($ip, $port);
>>>>>>> $q->SetDBData($fmdb,$lay . 'parentlist');
>>>>>>> $q->SetDBPassword($fmpw[0],$fmpw[1]);
>>>>>>> $q->AddDBParam('email_lookup',$user);
>>>>>>> $r = $q->FMFind();
>>>>>>>
>>>>>>> in FileMaker:
>>>>>>> email_lookup = calc...
>>>>>>> Substitute ( email ; "@" ; "" )
>>>>>>> works for me!
>>>>>>> HTH...
>>>>>>> Michael
>>>>>>> Michael Layne  |  9 degrees development  |  9degrees.com  |
>>>>>>>  skype:laynebay
>>>>>>> On Sep 10, 2008, at 9:40 AM, DC wrote:
>>>>>>>
>>>>>>> search the archives... this one is a chestnut. anyone make  
>>>>>>> progress on
>>>>>>> that
>>>>>>> FAQ we started last year?
>>>>>>>
>>>>>>> http://www.google.com/coop/cse?cx=013867382578033190853% 
>>>>>>> 3Axht3ywlmfpc
>>>>>>>
>>>>>>> cheers,
>>>>>>> dan
>>>>>>>
>>>>>>> william.downs wrote:
>>>>>>>
>>>>>>> Hi Josh,
>>>>>>>
>>>>>>> Surely using double == works ?
>>>>>>>
>>>>>>> as in $medFind->AddDBParam('Email',"==".$medEmail);
>>>>>>>
>>>>>>> I may be lost here though
>>>>>>>
>>>>>>> William
>>>>>>>
>>>>>>> On 10 Sep 2008, at 12:57, Josh Shrier wrote:
>>>>>>>
>>>>>>> How do you do a search in PHP for an email in Filemaker. When it
>>>>>>> performs a
>>>>>>> regular search the "@" in the e-mail address forces a no  
>>>>>>> records found
>>>>>>> result during the find. The only way to find it is the use ""  
>>>>>>> around
>>>>>>> the
>>>>>>> address. I do not know how to solve this during a PHP query.  
>>>>>>> Please
>>>>>>> assist.
>>>>>>>
>>>>>>> -Josh Shrier
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>>
>>>>>>> FX.php_List mailing list
>>>>>>>
>>>>>>> FX.php_List at mail.iviking.org  
>>>>>>> <mailto:FX.php_List at mail.iviking.org>
>>>>>>>
>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>
>>>>>>>
>>>>>>> ---------------------------------------------------------------- 
>>>>>>> --------
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>>
>>>>>>> FX.php_List mailing list
>>>>>>>
>>>>>>> FX.php_List at mail.iviking.org
>>>>>>>
>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> FX.php_List mailing list
>>>>>>> FX.php_List at mail.iviking.org
>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> FX.php_List mailing list
>>>>>>> FX.php_List at mail.iviking.org
>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>
>>>>>>>
>>>>>>
>>>>> _______________________________________________
>>>>> FX.php_List mailing list
>>>>> FX.php_List at mail.iviking.org
>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list