The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 8 posts ] 
Author Message
PostPosted: Wed Jun 22, 2011 11:20 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon May 31, 2010 1:58 pm
Posts: 6
Dear Community Builders,

I'm busy building a new dealersystem.
We built bikes (www.santosbikes.com) and distribute those bikes to our Dealers.

Our current Dealersystem is pretty [censored]'d :laugh: and is imported within a iframe.
So it's time for a new one.

http://santosbikes.com/index.php?option=com_comprofiler&task=userslist
There is our 'Dealer List'

But the standard search function is not what we want.

What do we want
A Dealer search system that is quiet simple.
Just a few ordinary functions.
You've to have the ability to search on:
1. Dealername
2. Do they have showroom bikes and a color screen? (checkbox)
3. Bikes.

Well I got stuck at the 3rd.
When I look for a bike:
"SCC 03 Special"
It will also show the Dealers that have the bike:
"SCC 03 Rohloff/riem"
Because the first part of the search does match.

How can we get this out of the system?
So when we search for:
"SCC 03 Specials"
Only the dealers with the SCC 03 specials will show up, and those with a SCC 03 Derailleur won't.

Would be great if someone could help me.

Best Regards,
Dylan Damsma


Top
 Profile  
 
PostPosted: Wed Jun 22, 2011 11:51 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jun 22, 2011 4:01 am
Posts: 32
does your sql write as `database_field` LIKE '%SCC 03 Specials%' or `database_field` LIKE '%SCC 03 %' ?


Top
 Profile  
 
PostPosted: Wed Jun 22, 2011 11:57 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon May 31, 2010 1:58 pm
Posts: 6
mrphp47 wrote:
does your sql write as `database_field` LIKE '%SCC 03 Specials%' or `database_field` LIKE '%SCC 03 %' ?


haha it's maybe a silly qeustion. But where am I able to see that? In phpmyadmin or somewhere in the script?


Top
 Profile  
 
PostPosted: Wed Jun 22, 2011 12:00 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jun 22, 2011 4:01 am
Posts: 32
in the search plug-in or component or module you created you have the search sql just echo that and post it here if you don't mind


Top
 Profile  
 
PostPosted: Wed Jun 22, 2011 12:05 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon May 31, 2010 1:58 pm
Posts: 6
mrphp47 wrote:
in the search plug-in or component or module you created you have the search sql just echo that and post it here if you don't mind


The Community Builder settings are on:
Simple any word match: Only 'any of' and Ranges

Other options are:
Simple Exact Match: Only 'is' and ranges
&
All Possibilities


I can't find the search function somewhere in the Community Builder scripts. Have been looking for it for an hour.. :-\


Top
 Profile  
 
PostPosted: Wed Jun 22, 2011 1:48 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jun 22, 2011 4:01 am
Posts: 32
Simple Exact Match will do Simple any word match: Only 'any of' and Ranges will search the words separately


Top
 Profile  
 
PostPosted: Fri Jul 01, 2011 10:10 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon May 31, 2010 1:58 pm
Posts: 6
This problem still isn't solved.

When I set the settings on "simple exact match", then the search results always stay blank, no matter what I'm searching for. Even when I know it IS in the searchable fields, it still won't it find it.

Really need to solve this! Can someone help ;) ?


Top
 Profile  
 
PostPosted: Fri Apr 27, 2012 5:22 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Nov 06, 2011 4:48 pm
Posts: 2
This is driving me crazy. I have joomla 2.5.4 installed and I am using K2. When you enter a phrase...say heart disease and choose exact phrase you get every article with either word as well as the phrase. So you have to go through all of the articles one at a time to find the relevant content. The results should parse the articles with the exact match in the title first and then the articles with the phrase...not every freakin article on the the site with either word or partial word. How to I fix this? I can't find any reference on this problem elsewhere. I tried RokAjaxSearch and the only comment they have on there forum is "rokajaxsearch is based on the mod_search core function and should behave like that. if you need it to behave differently, then i suggest that you search or ask at the joomla.org forum." So here I am...any ideas?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 



Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group