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

[Joel Shapiro]

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