[FX.php List] Errors searching for email addresses

[Joel Shapiro]

Hi Bob

To my understanding: Unicode indexing is set per field in FMP,  
nothing to do w/ PHP sites.  (it uses a specific unicode for the @  
symbol so the FileMaker wildcard wouldn't take over when using it in  
a search, but it also means that entering bob at Patin.com would not  
match bob at patin.com -- lowercase and uppercase have different unicodes)


Hi Jonathan

see my list post from Sept 5 2008: "Re: [FX.php List] [OFF] Filemaker  
Web Security?":
<http://www.iviking.org/pipermail/fx.php_list/2008-September/ 
008037.html>

As Troy Meyers correctly reported and I finally saw for myself,  
double-equal '==' and quotes alone are definitely not sufficient

FWIW: the link above strips out the @ in my sample password.  It's  
meant to be "p at 55w0rd", not "p at 55w0rd"

-Joel


On Jan 26, 2009, at 10:49 AM, Jonathan Schwartz wrote:
> Talk to me about spoofing login.
>
> If the "==" is used, how would wildcards succeed?
>
> Thanks
>
> J


On Jan 26, 2009, at 11:39 AM, Bob Patin wrote:

> I'm using UTF-8 on all my sites; does that mean that this is adequate?
>
> $query->AddDBParam('username','=='.$username);
>
> BP
>
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> Twitter: bobpatin
> iChat/AIM: bobpatin
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance & TechNet
> --------------------------
> FileMaker hosting and consulting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>
> On Jan 26, 2009, at 1:20 PM, Gjermund Gusland Thorsen wrote:
>
>> If you use Unicode indexing, wildcards are no longer an issue  
>> either...
>>
>> ggt
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list