Search Problem - Remository Forum

Home

Forum

Remository Forum

home | post reply | threaded view | help | rules

Boardwalk :: Forum List

Remository

Support Remository 3.4+

deer

Karma: 1

Search Problem - 2011/10/23 09:18 I have remository 3.53 installed on Joomla 1.5.20
when I need to search using the top search box.
then i have to write the exact word with case sensitive letters. for example
if I search for the word "Film" in the remository files then I have to write it "Film", but if i write "film" no results retrieved from the search.

please: any one can help me to fix this issue, i need to do case insensitive search

Thank you

| | Sorry, you do not currently have permission to write here.

ahmed.m.mahdi Karma: 0	Re:Search Problem - 2011/10/23 11:16 you can do that by adding a LOWER function to data wich come from database and textbox . you can find that in rimositoryFile.php . approximately on line 1028 thanks Post edited by: ahmed.m.mahdi, at: 2011/10/23 11:40
	\| \| Sorry, you do not currently have permission to write here.

deer

Karma: 1

Re:Search Problem - 2011/10/23 11:55 Many thanks Ahmed ,that's right

i did the following modification

file path
components/com_remository/p-classes/remositoryFile.php

line 1029:
foreach ($seek_fields as $field) $orcondition[] = "$field LIKE '%$search_text%'";

will be:
foreach ($seek_fields as $field) $orcondition[] = "LOWER($field) LIKE LOWER('%$search_text%')";

Post edited by: deer, at: 2011/10/23 11:57

| | Sorry, you do not currently have permission to write here.

Boardwalk :: Forum List Remository Support Remository 3.4+

Aliroboard Forum Component 1.2
Aliro Software

Advice Notes

Login

Subscribe to Premium Support

Get priority support for Remository and Glossary, sign up now for a Premium Support monthly subscription:

Or purchase a year's support:

Recommended SEF

Who is Online

Remository welcomes guests and visitors

remository