Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › No results › Reply To: No results
February 9, 2017 at 12:54 am
#11862
Hi!
The problem is the “prijs” price field. I’ve checked one of the car pages, and that field is not numeric, therefore that filter always fails: https://i.imgur.com/l0CdOzf.png
For example: € 2.950 – MySQL cannot cast a field to numeric for BETWEEN operations if there is other than numbers and decimal points are present. In this case the correct value must be simply 2950
I recommend formatting the price in the output process, when printing the field value. It’s much better, as you will be able to do queries based on prices.
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)