[FX.php List] Searching...

[Chris Hansen]

Milosh,

No, or at least I would suspect unpredictable results.  The reason: 
greater than and less than comparisons only work for numbers, and 
quotations marks are best used for text searches (they're unnecessary 
for number searches -- see my earlier post.)  HTH

--Chris Hansen
   creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On Dec 13, 2004, at 12:41 PM, Milos Vukotic wrote:

> 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
>>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>