Search Results String

15 posts by 4 authors in: Forums > CMS Builder
Last Post: June 13, 2011   (RSS)

By dccreatives - May 10, 2011

I want to call some items on a brands page to include those where the values are not zero.

http://www.axislighting.com/CMS/brandsList_row-config.php?row%20configuration%20path=0

On this page, I have set the row configuration path for the brands that do not have row configurations to '0'.

The above link shows the ones set to zero.

How can I link it to show the ones that are not equal to zero (0)?

Please advise.

Re: [Jason] Search Results String

By dccreatives - May 10, 2011

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.

Re: [dccreatives] Search Results String

By Jason - May 10, 2011

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
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Search Results String

By dccreatives - May 10, 2011

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

Re: [dccreatives] Search Results String

By Jason - May 10, 2011

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.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [dccreatives] Search Results String

By Dave - May 10, 2011

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.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Search Results String

By dccreatives - May 31, 2011

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.

Re: [dccreatives] Search Results String

By Jason - June 2, 2011

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
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Search Results String

By dccreatives - June 2, 2011

When I perform a search it gives me the results of the keyword search correctly, but on the search.php form.

While this search is correct, I would rather them go directly to an overview page for that keyword.

I have a textfield in the Admin with a link called 'link'. Can I indicate in the form action to pull the 'link' field from the keyword search?