[FX.php List] Searching...

Tue Dec 21 08:14:54 MST 2004

Vinnie,

To answer your questions:

1) indexing language is specified in FileMaker.  When you specify a 
field, and set it up as indexed, you can also choose the language to 
use for indexing.

2) Are you running under windows by chance?  From what I've read, 
windows limits the number of users that can be connected at once.  If 
that's not the case, what sort of errors exactly are you seeing?

HTH

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

On Dec 13, 2004, at 12:56 PM, Vinnie P. Taranto wrote:

> Hello,
>
> I had 2 questions,
>
> How do you specify the indexing language as ASCII in FMFind()?
> and
> How do you configure the number of simultaneous sessions PHP can 
> handle?
> I'm running Apache 1 and I can't find the value in either the Apache or
> PHP config files. The reason I'm asking is because I've created a web
> database and I always get a bunch of session variable errors when the
> load gets heavy.
>
> Thanks for all yous guys do.
>
> Vinnie Taranto
> Technology Specialist & Database Engineer
> Dean of Students Office
> University of Florida
> MAIN: (352) 392-1261
> FAX: (352) 392-1261
> TDD: (352) 392-5566
> TOLLFREE: (877) 9UF-DEAN
> WEB: http://www.dso.ufl.edu
> EMAIL: vinniept at dso.ufl.edu
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Chris Hansen
> Sent: Monday, December 13, 2004 1:47 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Searching...
>
> 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
>