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

[Gjermund Gusland Thorsen]

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
>