More Search Function Questions
14 posts by 7 authors in: Forums > CMS Builder
Last Post: October 18, 2010 (RSS)
By InHouse - February 17, 2009
1 - My search responses using the 'multisearch' option seem to be case sensitives. Can anyone point me in the direction of making it case insensitive?
2 - The multisearch method allows me to respond to a query with a title field and a summary field in the printed results. Is there any way to access more values from the found records in the the response list?
Many thanks,
J.
Re: [InHouse] More Search Function Questions
By Dave - February 17, 2009
It shouldn't be case sensitive as it uses the MySQL "LIKE" function which is case-insensitive. If you can send me CMS and FTP login details to dave@interactivetools.com I could check it out for you. (Email, don't post login details to the forum).
As for multisearch, it's fairly limited. If you want to tell me about what you're trying to do via email we can see if it can be easily extended for what you need.
Hope that helps!
interactivetools.com
Re: [Dave] More Search Function Questions
By InHouse - February 17, 2009 - edited: February 18, 2009
Details to follow by email.
Cheers,
J.
Re: [Dave] More Search Function Questions
By Djulia - April 12, 2009 - edited: April 12, 2009
I encounter the same problems (1 and 2).
For the problem 2, I would like to obtain an image with the _summary :
<?php if ($upload['hasThumbnail']): ?> ...
There is a possible solution ?
Thanks for your assistance.
Djulia
Re: [Djulia] More Search Function Questions
By ross - April 13, 2009
Did we ever get FTP details from you for this one? I think we'll need to take a closer look at what's going on.
Thanks!
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
Re: [ross] More Search Function Questions
By Djulia - April 13, 2009
Thanks for your answer.
I have just sent FTP details.
Djulia
Re: [Djulia] More Search Function Questions
By ross - April 14, 2009
I'll be in touch as soon as possible :).
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
Re: [InHouse] More Search Function Questions
By Djulia - April 25, 2009 - edited: April 25, 2009
You found a solution to problem 1?
I have the same problem and I do not know if it is the configuration of my server which causes this problem.
Thanks for your feedback.
Djulia
Re: [Djulia] More Search Function Questions
By InHouse - April 25, 2009
As a first step I've converted this to a normal section search. You can see the docs for that here: http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html
Basically, I use the standard list viewer code at the top:
list($searchRows, $searchDetails) = getRecords(array(
'tableName' => 'events',
'perPage' => '20',
));
Then I create a search field like this (as per docs):
<input type="text" class="input1"
name="region,primary_community,location,start,description,sponsor,contact_name_keyword"
value="<?php echo htmlspecialchars(@$_REQUEST['region,primary_community,location,start,description,sponsor,contact_name_keyword']); ?>"
size="35" maxlength="50" style="display: inline; margin-top: 0px; margin-right: 10px;"/>
Then instead of <?php echo $record['_title'] ?> I use <?php echo $record['primary_community'] ?>. And instead of <?php echo $record['_summary'] ?> I use <?php echo $record['start'] ?>. You should be able to access other fieldnames now as well.
By default it will show all results if there are no search terms. You can override that with this option:
'requireSearchMatch' => '1', // optional, don't show any results unless search keyword submitted and matched
This seems to have fixed the case sensitivity issue. Have a look at my version and let me know if you have any questions or need any more help with it.
In this case it worked well for me as this search function was only polling one Section Editor for values. I'll go on record to say that I've never really understood the basic search functions of CMSB so I don't claim any particular insight into this fix.
I hope it help you though. I certainly solved my issue completely!
J.
Re: [InHouse] More Search Function Questions
By Djulia - April 26, 2009
Thank you for your answer, I appreciate much. [:)]
I did not succeed in finding the solution with the answer of Dave. :(
That seems more complex and remains obscure for me.
I think that the solution will be found in the future by Dave and its team.
Djulia