[FX.php List] Stupid Find Question
Dale Bengston
dbengston at preservationstudio.com
Tue Dec 21 21:30:09 MST 2004
My apologies. It was Marisa's second post that mentioned returned
results. Slinking back into my hole now....
Dale
On Dec 21, 2004, at 1:34 PM, DC wrote:
> um...
>
> > "But I end up with an error 401."
>
> last i checked error 401 meant "No records match the request"
>
> Maybe the original poster, Marisa Smith could chime in here with the
> outcome, instead of all of us jabbering this way and that.
>
> DC
>
> Dale Bengston wrote:
>> 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
>>>
>> _______________________________________________
>> 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