[FX.php List] Stupid Find Question
DC
dan.cynosure at dbmscan.com
Mon Dec 20 11:03:55 MST 2004
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
>
More information about the FX.php_List
mailing list