2. PHPRunner General questions
  3. More than.. not working
This topic is locked

More than.. not working

 		2/28/2008 19:45:39
PHPRunner General questions
J
 jackel66 author

When i do a search on a Number field (IE 1,2,3,4,5,6) it will return a correct result up to 10 then after 10 it doesnt show anything. So if i search or say field more than 10 i get no results. but if i search for field more than 5 i get up to 9 then nothing after 10. SAme with the Less than field. any help with this would be appreciated.
thanks
Alexey admin 2/29/2008

Hi,
looks like your field has VARCHAR type in the database.

Try to change it to INT and then rebuild your project.
If this doesn't help publish your project on Demo Account (last tab in PHPRunner) and send a URL where I can see and troubleshoot this issue to support@xlinesoft.com
J
 		jackel66 author 3/1/2008

Right now the Column is Int(10) not VARCHAR, but i will publish to a demo account when i get home. I appreciate the help with this.....
J
 		jackel66 author 3/2/2008

Hi all,
After tinkering wit my DB a bit i found that the More Than / Less Than wouldnt work unless i set it to Medium INT (auto) value. but it now works.
i appreciate all the help