No results

[Barbara]

Hi,

How or where can I view the exact query used in a search?

I created Custom Fields, but when I search I always get No results!

Or maybe you can see from my print_r of $args why it doesn’t work (see attachment)?

Thanks,
Barbara

[Barbara]

You cannot access this content.

[Barbara]

I only get results when I set Custom Fields connection Logic to OR.

[Ernest Marcinko]

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: http://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.

[Barbara]

Thank you, thank you, thank you! I feel so stupid right now 😛

[Ernest Marcinko]

You cannot access this content.

[Author]

Posts