Reply To: No results

#11862
Ernest Marcinko
Ernest Marcinko
Keymaster

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.

Best,
Ernest Marcinko

If you like my products, don't forget to rate them on codecanyon :)