[FX.php List] [OFF] Range of values query in the API

[Bob Patin]

What about just putting a calc field in the db, so that you can just  
search the field rather than dealing with a range...

Or what about putting 2 lines, with the less than/equal to operator in  
the first one, and the greater than/equal to in the 2nd line? Haven't  
tried it, nor have I used operators in the API, but I assume they're  
there somewhere...

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
Twitter: bobpatin
iChat: bobpatin
AIM: longterm1954
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance & FileMaker TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
Web hosting • PHP • Full email services • Free DNS hosting •  
Colocation • Consulting


>
>
>> Hi Folks,
>>
>> Sorry, once again for the API question here in fx.php list.  After  
>> a solid 2 hours of searching for the answer, I figure I have earned  
>> it. Perhaps it will help another fx'er.
>>
>> So....How do you search for a range of values in the API?
>>
>> This doesn't work:
>>
>> 	$find->AddFindCriterion('Credit_Card_Expires',"0...90");
>
> I'd set up the criteria as a variable and see what happens - it  
> could also be the double quotes instead of single, but I'm not that  
> API aware.
>
> $expire = "0...90";
> $find->AddFindCriterion('Credit_Card_Expires', $expire);
>
> Cheers
>
> Webko
> And *both* .. and ... have worked since at least v4,1 - out of  
> habit, I use ... even afetr I found that FM doesn't seem to care
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list