[FX.php List] Searching...

[Milos Vukotic]

Finally the good one! But does this work for number greater than or less 
than comparisons?

Thanks,
Milosh

Chris Hansen wrote:

> Greetings!
>
> A tip on doing finds with FX.php: finds via FX work the same way that 
> they do in FileMaker.  So characters like '@' and '*' which are 
> wildcards in FM, are also wildcards when you search via FX.php.  When 
> doing a login, an excellent options is to add quotes around your 
> parameter like this (using a modified version of the example below):
>
> $query->AddDBParam('email_password', '"' . $user . $pass . '"');
>
> Of course, this means that you'll be doing an exact search, but for a 
> login, that's exactly what you want.
>
> Another suggestion, when creating password fields, it can be very 
> useful to specify the indexing language as ASCII.  Not only does this 
> make special characters behave, but it also makes searches case 
> sensitive; which is again perfect for passwords.
>
> HTH
>
> --Chris Hansen
>   creator of FX.php
>   "The best way from FileMaker to the Web."
>   www.iViking.org
>
> On Dec 13, 2004, at 11:08 AM, Jim Bowser wrote:
>
>> 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
>>>
>>
>> _______________________________________________
>> 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
>