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.
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.