[FX.php List] Stupid Find Question

Milos Vukotic milos at mcservices.com
Mon Dec 20 11:23:15 MST 2004


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
>




More information about the FX.php_List mailing list