Finder not giving correct results

[null_pointer]

Hi ,
i have defined a finder in jaws.xml like this.


findPrice
(Price BETWEEN {0} AND {1})



Now when i call findPrice with 0 and 200 i get records where the price is out of this range (0-200) and there after the same result is repeater no matter whatever is the parameter.

but if put a constant there in the xml file like
Price BETWEEN 0.0 and 200.0 then i get proper results

anyone what could be the problem?.
thanks.

[dsundstrom]

This is a database thing all queries are executed in the database. Take a look at the sql that Jaws is generating. Try to execute it by hand in your database and see what the results are.