[FX.php List] Stupid Find Question

Dale Bengston dbengston at preservationstudio.com
Tue Dec 21 12:26:10 MST 2004


Since the original post mentions returning actual results - just not  
the expected results - I think we can rule out the field not being on  
the layout.

Dale

On Dec 21, 2004, at 12:49 PM, DC wrote:

> it's probably a fact of the field not being present on the layout or  
> the layout being named something else than what is in the code.
>
> DC
>
> Dale Bengston wrote:
>> So does anyone have a resolution to Marisa's original question of  
>> "or" searches for two user inputs in the same field? Short of Steve's  
>> back-end scripting conclusion?
>> Dale
>> --  
>> Dale Bengston | Streamline Studio, LLC |  
>> dbengston at streamline-studio.com
>> Associate Member, FileMaker Solutions Alliance
>> On Dec 20, 2004, at 4:15 PM, Michael Layne wrote:
>>     I'm glad to have read this. I had a suggestion on dealing with  
>> '@',
>>     using PHP 'str_replace' function and when I saw Chris' solution  
>> [],
>>     I immediately tried it thinking I over-thought things, but it  
>> didn't
>>     work for me. I thought I was missing something.
>>     Thanks for clarification.
>>     On Dec 20, 2004, at 3:20 PM, DC wrote:
>>         Hi Milos,
>>         Thanks for catching that one! I apologize for misleading the
>>         list with my untested suppositions! Further comments and test
>>         reports inline below...
>>         Milos Vukotic wrote:
>>             If this is true:
>>              > Chris Hansen wrote:
>>              > 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
>>             . '"');
>>             I would rather say instead of
>>              > resulting string sent to filemaker field find request:
>>              > ="100"
>>             that resulting string sent to filemaker field find  
>> request:
>>             =100
>>             Correct me if I am wrong, or I am missing something?
>>         Yes, on the correction you offer to this syntax point, you are
>>         right; my placing of double-quotes was wrong. FX does not in
>>         fact place double-quotes around a search term.
>>         However, I tested the code below to determine if your guess
>>         would pan out... and ...this code will not find the spurious
>>         records as you opine it might:
>>          >> Milos Vukotic wrote:
>>          >>
>>          >>> I would guess that you'll get for $num_ser = 1
>>          >>> all this records:
>>          >>> 1,11,12,13..,101,...,1000,...,10000,...
>>          >>>
>>          >>> Cheers,
>>          >>> Milos Vukotic
>>          >>>
>>          >>> DC wrote:
>>          >>>
>>          >>>> I've gotten this code to work without a problem:
>>          >>>> foreach ($FK_array as $num_ser)
>>          >>>> {
>>          >>>> $request->AddDBParam ('num_serial', $num_ser, 'eq');
>>          >>>> }
>>          >>>>
>>          >>>> // tell FMP/FX to do an OR search
>>          >>>> $request-> AddDBParam ('-lop', 'or');
>>          >>>> // call the find action
>>          >>>> $result_array = $request-> FMFind();
>>          >>>>
>>         For example, a record with num_serial 250 is not found in a
>>         search for record with num_serial 25.
>>         Hope that clears the issue.
>>         Best,
>>         dan
>>             Cheers,
>>             Milos Vukotic
>>             DC wrote:
>>                 The way I understand it (and what I have seen on the  
>> web
>>                 database by doing a Find Again and looking at what is
>>                 sitting in the field) the 'eq' parameter wraps the  
>> data
>>                 sent to the find request like so:
>>                 data sent to FX:
>>                 $request->AddDBParam ('num_serial', '100', 'eq');
>>                 resulting string sent to filemaker field find request:
>>                 ="100"
>>                 When you do a search with the equals sign, you don't  
>> get
>>                 1000 or 10000, you just get 100.
>>                 Correct me if your tests show anything different.
>>                 Not sure if you know this, but a neat trick to get the
>>                 even stricter == find request to work is to prepend  
>> the
>>                 equals sign to the search term and use the 'eq' param.
>>                 $strict_eq_search = '=' . '100';
>>                 $request->AddDBParam ('num_serial', $strict_eq_search,
>>                 'eq');
>>                 This allows you to do what filemaker calls 'Field
>>                 content match' as opposed to the 'eq' param which only
>>                 does a (so-called) 'Exact match'.
>>                 I'm using an older FX version, has field content match
>>                 been added as a paramter option to a new version?
>>                 Best,
>>                 dan
>>                 Milos Vukotic wrote:
>>                     I would guess that you'll get for $num_ser = 1
>>                     all this records:
>>                     1,11,12,13..,101,...,1000,...,10000,...
>>                     Cheers,
>>                     Milos Vukotic
>>                     DC wrote:
>>                         I've gotten this code to work without a  
>> problem:
>>                         foreach ($FK_array as $num_ser)
>>                         {
>>                         $request->AddDBParam ('num_serial', $num_ser,
>>                         'eq');
>>                         }
>>                         // tell FMP/FX to do an OR search
>>                         $request-> AddDBParam ('-lop', 'or');
>>                         // call the find action
>>                         $result_array = $request-> FMFind();
>>                         Another thing to check is make sure that  
>> you're
>>                         talking to the right layout (one that has the
>>                         fields you wish to search on). I see 401  
>> errors
>>                         all the time when I make a typo in the layout  
>> name.
>>                         DC
>>                         Marisa Smith wrote:
>>                             OK, I KNOW I should know how to do this,  
>> but
>>                             I can't figure it out
>>                             I need to find all records whose unitid=15
>>                             OR whose
>>                             unitid=20
>>                             In Filemaker client, I can do this with a
>>                             'new request', but I don't know
>>                             the equivalent in XML. I tried this:
>>                              
>> $AAHRPPDocQuery->AddDBParam("unitid","15");
>>                             $AAHRPPDocQuery->AddDBParam("-lop","or");
>>                              
>> $AAHRPPDocQuery->AddDBParam("unitid","20");
>>                             But I end up with an error 401.
>>                             What am I missing here? Or am I trying to  
>> do
>>                             the impossible?
>>                             Thanks!
>>                             Marisa
>>                              
>> ---------------------------------------------------------------------
>>                             Marisa Smith, President
>>                             DataSmith Consulting, LLC
>>                             667 Kuehnle Street
>>                             Ann Arbor, MI 48103
>>                             Phone & Fax: (734) 369-3001
>>                             Cell: (734) 834-2638
>>                             http://www.datasmithconsulting.net
>>                             Filemaker Solutions Alliance Associate  
>> Member
>>                              
>> _______________________________________________
>>                             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
>>             _______________________________________________
>>             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
>



More information about the FX.php_List mailing list