[FX.php List] Stupid Find Question
Gjermund Gusland Thorsen
ggt667 at gmail.com
Tue Dec 21 02:28:30 MST 2004
This is how I did it in 2000 using FileMaker 5.0/5.5:
$searchID[]=15;
$searchID[]=20;
$AAHRPPDocQuery->AddDBParam( 'unitid', implode( "\x0D", $searchID ) );
On Mon, 20 Dec 2004 21:54:15 -0600, Dale Bengston
<dbengston at preservationstudio.com> 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
>
>
>
More information about the FX.php_List
mailing list