[FX.php List] character encoding issue?

[Derrick Fogle]

Yeah, you can't search with a @ even in the native interface. For  
exact address/domain matching, I've had to create calculated fields  
that hold each separately - a email_domain field and an email_address  
field to search against, and then use explode() in PHP to get  
separate values from an email address and do the search that way.

FMP:
email_domain [calculation, result=text] =
Right( email_whole ; Length(email_whole) - Position ( email_whole ;  
"@" ; 1 ; 1 ) )

email_address [calculation, result=text]  =
Left( email_whole , Position ( email_whole ; "@" ; 1 ; 1 ) - 1 )


PHP
$email_parts = explode( '@' , $email_whole );

$emailquery->AddDBParam("email_address", "=".$email_parts[0]);
$emailquery->AddDBParam("email_domain", "=".$email_parts[1]);


HTH,

On Feb 16, 2006, at 4:23 PM, Dale Bengston wrote:

> I believe the @ character is a wild-card character in FMP searches.  
> I will be staring this problem in the face very soon myself, so I  
> await the responses from the great people on this list!


Derrick Fogle
derrick at fogles.net