This topic is locked
[SOLVED]

 Numeric data search results not correct

2/16/2010 3:03:05 AM
PHPRunner General questions
C
chrisj1963 author

Hi,

Can you give me any ideas as to why "search for" a number using "contains", "equals", or "starts with" generates good search results but if I try to search for a number that is "more than", "less than", "Equal or more than", "Equal or less than" it seems to filter some of the results, but they don't seem to have any filter logic that I can understand.
This is true for all number fields in my table. I have one field that is currency with 2 decimals. When I search on 1.xx searches are fine. When i enter a decimal that is less than $1.00 as e.g. .95 I get empty resutls, but if I enter 0.95 I get proper results.
Both the number and the currency sort perfectly when clicking the column header...
Am I doing something wrong?
Any insights would be appreciated.

J
Jane 2/16/2010

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

C
chrisj1963 author 2/16/2010



It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.


Actually I figured it out. Thank you anyway!