[FX.php List] character encoding issue?

[Bob Patin]

I've used


$search2->AddDBparam('email','=='.$email);

without any problems. Am I missing something here? I've used this for  
a login routine and it works fine...

Bob



On Feb 16, 2006, at 4:36 PM, Derrick Fogle wrote:

> 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
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list