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

Joel Shapiro jsfmp at earthlink.net
Wed Sep 10 10:24:44 MDT 2008


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



More information about the FX.php_List mailing list