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

[Gjermund Gusland Thorsen]

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
>>
>>
>