[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