More Search Function Questions

14 posts by 7 authors in: Forums > CMS Builder
Last Post: October 18, 2010   (RSS)

By InHouse - February 17, 2009

Two more silly questions:

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

Hi J,

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!
Dave Edis - Senior Developer

interactivetools.com

Re: [Dave] More Search Function Questions

By Djulia - April 12, 2009 - edited: April 12, 2009

Hi Dave,

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

Hi Djulia

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

Hi Ross,

Thanks for your answer.

I have just sent FTP details.

Djulia

Re: [Djulia] More Search Function Questions

By ross - April 14, 2009

Hi Djulia

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

Hi J.,

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

I can't claim any points for this solution. (Super) Dave fixed the issue and left me the following explanation:

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

Hi J.,

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