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: [dccreatives] Search Results String

By Jason - May 10, 2011

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
---------------------------------------------------
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

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: [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?