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

[Gjermund Gusland Thorsen]

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
>