[FX.php List] Searching...

[FX]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 2020 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20041213/d0f73cba/attachment-0001.bin