2. PHPRunner General questions
  3. [SOLVED]  Search on numeric values
This topic is locked
[SOLVED]

 Search on numeric values

 		12/1/2009 6:36:00 AM
PHPRunner General questions
W
 wpl author

Hi,
is there any possibility to do a real search on numeric values (like > 500, < 10000)? The search/advanced search tools will only search for the "value" of the character codes, I suppose. Any chance to do a true numeric search?
thanks a lot
J
 		Jane 12/1/2009

Hi,
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.
W
 		wpl author 12/1/2009



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



Jane,
well, the matter is that search will treat numbers as text and thus will not give meaningful search results: I have got a field containing areas in square meters. If I ask to query for area between 1000.00 and 1200.00, I get the following results:
111.94, 1130.32, 1156.42, 1136.16, 1013.49, 1198.14, 1136.06, 11193.02, 1152.63, 1145.48, 1199.67, 10444.99, 10369.56, 1103.46,

11794.16, 1078.13, 10275.11,....
TIA for any hints
J
 		Jane 12/2/2009

Hi,
I can't say what's wrong with search without your 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.
W
 		wpl author 12/2/2009

Jane,
sorry for that - stupid me.... I was working on a set of tables I did not design myself. And the field in question was created as character varying! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=45873&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />. That explains the strange behaviour of the query. I should have noticed that before. Sorry and thanks for your efforts.
regards