Gossamer Forum
Home : Products : DBMan : Customization :

Range searches (i.e., 3 < $x <= 12) ...

Quote Reply
Range searches (i.e., 3 < $x <= 12) ...
Hello, DBmasters. Me again trying to do something I probably shouldn't again.

Anyway, one of my databases has three zip code fields. $low, $high, $theZip.

I am trying to make sub query() return records that are between 2 zip codes, defined by $low and $high. The zip code to be tested is the third field, defined only for searching. I have a conditional that I can use to test the value of $theZip, but I am stumped as to how I can incorporate it into sub query. Has anyone successfully implemented a dual range check before?