Search Results String

Hi,

If your allowing CMS Builder to do the automatic search for you and you want to search for values greater than 0, you can try this:
http://www.axislighting.com/CMS/brandsList_row-config.php?row%20configuration%20path_min=1
Adding _min means that it will return records where the fields value is only greater than or equal to the value (1).

For other options, take a look at this documentation page:

http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

Hope this helps

It does not work. I think I know why. The field is a text field to a url path. The only time I entered a '0' is when there is no url for that field.

Hi,

If you're looking for values that are not 0, it may be easier to just manually set your WHERE clause.

For example:


'allowSearch' => false,
'where' => "row configuration path_min != 0",

Hope this helps

Did I put it in the wrong place? I am attaching the file.



http://www.axislighting.com/CMS/brandsList_row-config.php?row configuration path_min=1

Hi,

The suffix "_min" is only used in the URL when doing an automatic search. Try this instead:

list($brandsRecords, $brandsMetaData) = getRecords(array(
'tableName' => 'brands',
'perPage' => '45',
'allowSearch' => false,
'where' => "`row configuration path` != 0",

));

Hope this helps.

Hi dccreative,

I think the problem in all these cases is you need to use underscores instead of space (" ") or instead of %20.

Hope that helps! Let me know if that fixes it for you.

Thanks,

That worked nicely.

One more thing. I have a search in my header.php which calls this:

<form method="POST" action="search.php" class="searchForm">
<td height="49" valign="top"><input name="name_keyword" type="text" value="" class="field" id="search" /></td>
<td height="49" valign="top"><input name="submit" type="image" value="SUBMIT FORM" src="images/button-go.jpg" border="0"></td>
</form>

I want that the results page should be the link code that we have for each keyword. For example we access each item with this link:

<?php echo $record['link'] ?> from the itemsRecord table. How can I add that the action should pull the keyword's 'link' record.

Also which records do I need to include on top of the header?

<?php

require_once "/services/webpages/a/x/axislighting.com/public/cmsAdmin/lib/viewer_functions.php";

list($itemsRecords, $itemssMetaData) = getRecords(array(
'tableName' => 'items',
'perPage' => '12',
));


list($globalRecords,$globalMetaData)=getRecords(array(
'tableName' =>'global',
'limit' => 1,
'allowSearch' =>0,
));

$global = $globalRecords[0];

?>



Thank You.

Hi,

I'm a little unclear as to the problem you're experiencing.

Currently, what happens when you perform a search? How does it differ from what you want to happen?

Let me know and we'll try to suggest a solution.

Thanks