Find Records within a Number Range

[randyinla]

Hi, I'm trying to find records with a number field that are greater than or less than 2 numbers, i.e. if I'm looking for the records greater than 115 and less than 120.

$myFind->addFindCriterion('ssvm', '>115');

$myFind->addFindCriterion('ssvm', '<120');
 

do I need

$myFind->setLogicalOperator(FILEMAKER_FIND_AND);   or am I way off base?

 

Thanks for your advice!

[webko]

addFindCriterion('ssvm', '115...120');

[randyinla]

thanks Webko, that's terrific.  you're a champ!

How would that work using variables?

addFindCriterion('ssvm', '$Num1...$Num2');

[webko]

Out of habit, I create the variable outside the actual request and then use it

$startNum = "115";

$endNum = "120";

$range = $startNum."...".$endNum;

addFindCriterion('ssvm', $range);

[randyinla]

thanks Webko, that's tight coding!