[FX.php List] Searching...

[Jim Bowser]

Keep in mind that email addresses can contain underscores and dashes and
periods in the username and they will affect your search results as much as
the @ symbol!


Jim Bowser
Network Manager
Shoreline Creations Ltd.
Publisher of:
  GROUP TOUR MAGAZINE
  STUDENT GROUP TOUR MAGAZINE

616-393-2077 x120
800-767-3489 x120
jim at grouptour.com
www.grouptour.com


On 12/13/04 12:38 PM, "FX" <fx at 9degrees.com> wrote:

> Milosh,
> 
> my way around this - I am using email addresses as a user ID for
> authentication -
> 
> on the PHP side:
> $user = str_replace("@","","emailaddress at server.com");
> $password = $_POST['password'];
> // then concatenate
> $userpass = $user . " . " . $password;
> ...
> $query->AddDBParam('email_password',$userpass);
> $result = $query->FMFind();
> ...
> on the FM7 side:
> //create a field that concatenates email and password
> name: email_password
> type: calculation
> calc = Substitute ( email ; "@" ; "" )& "." & password
> 
> Just removing '@' from the equation on both sides allows you to use the
> sumbitted email!
> 
> On Nov 22, 2004, at 10:41 AM, Milos Vukotic wrote:
> 
>> Not just number-fields, any fields with particular characters (like
>> "@")... Look at my previous posts.
>> There is NO good work around in FM7.  Maybe after v9 everything will
>> work as it is supposed to!?
>> 
>> Cheers,
>> Milosh
>> --
>> Milos Vukotic
>> Software Engineer
>> MC Services
>> http://www.mcservices.com
>> 
>> Baard Belsaas wrote:
>> 
>>> Hello, I have made my first fx-site in FM5, and get it working!
>>> Now I have converted this to FM7. After a bit of troubles I can
>>> acsess the
>>> database from the site, and searching on a text-filed is ok. But when
>>> I
>>> search on a number-filed its "game over"; the found counter is "-1"
>>> and the
>>> current error=401.
>>> 
>>> Search is the same to number- or textfield? Or have I sleeping in my
>>> fx-lessons?
>>> 
>>> 
>>> In kindness
>>> Baard Belsaas
>>> 
>>> 
>>> _______________________________________________
>>> 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
>> 
> _________________
> Michael Layne
> 9 degrees development
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>