[FX.php List] case sensitive query

[Chris Hansen]

Alex,

The easiest solution is probably to use unicode indexing on that  
field.  Of course, that makes all searches case sensitive, but that's  
often what you want in such cases.  Come to think of it, I think it  
would work to have two fields: one a calc with unicode indexing, the  
other the main field with the default indexing (or vice versa).  That  
would give you the flexibility to have case sensitivity or not, as  
the situation dictated.  HTH

--Chris Hansen
   FileMaker 8 Certified Developer
   FileMaker 7 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org


On Jul 19, 2007, at 4:14 PM, Alex Gates wrote:

> While I'm at it...
>
> Anyone know a trick to make queries case sensitive?
>
> for example, if alex is my username, I can still log in with Alex  
> or ALEX or aLeX.
> Any special trick to make it case sensitive?
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>