More Search Function Questions

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!

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

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!

Hi Ross,

Thanks for your answer.

I have just sent FTP details.

Djulia

Hi Djulia

I'll be in touch as soon as possible :).

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

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.

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