Joomla Extensions Club 20,483 posts

[pleverell Friend pleverellJoin date: September 2007Posts: 7Downloads:5Uploads:0]

#204538

I am using filtering on a site I am developing and need some help.

http://www.tdp-development-site.co.uk/usat/find-a-hotel

If you type ‘Hilton’ into the Hotel Name you get the expected suggestions as a drop down. however if you type ‘hilton’ nothing appears. i.e. it id case sensitive.

Can I make this NON case sensitive?

All help appreciated.

cheers
Paul L

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#562556

Hello pleverell

you can solve the problem with my below tweak:

change this query from file : com_jak2filtersitemodelssuggestions.php

at line : 30-36
[PHP]$query = ”
SELECT `labels`
FROM #__jak2filter_taxonomy
WHERE `labels` LIKE ‘%”.$xf_value.”%’
AND `asset_id` = {$xf_id}
GROUP BY `labels`
“;[/PHP]

to :
[PHP]$query = ”
SELECT `labels`
FROM #__jak2filter_taxonomy
WHERE LOWER(`labels`) LIKE LOWER(‘%”.$xf_value.”%’)
AND `asset_id` = {$xf_id}
GROUP BY `labels`
“;[/PHP]

[pleverell Friend pleverellJoin date: September 2007Posts: 7Downloads:5Uploads:0]

#562814

Thanks, this has done the trick

[Author]

Posts