url search & search engine by date range

5 posts by 2 authors in: Forums > CMS Builder
Last Post: July 19, 2011   (RSS)

By markr - July 16, 2011

I thought I once saw support documentation on how to do a:

a. url search, and
b. search engine

.. by date range but now I can't find (maybe never saw) it.

Perhaps there a thread here I too cannot find?

Re: [markr] url search & search engine by date range

By Jason - July 18, 2011

Hi,

Could you give some more detail on what you want to accomplish?

You can start by taking a look at this portion of the online documentation:
http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html
This gives some basics on creating search forms.

Hope this helps get you started,
---------------------------------------------------
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: [markr] url search & search engine by date range

By Jason - July 19, 2011

Hi,

You would have to do a custom WHERE clause. For example, if you set up your URL like this:

listView.php?publishDateMin=2010-08-01&publishDateMax=2011-07-31

You can set up your query like this:

list($articleRecords, $articleMetaData) = getRecords(array(
'tableName' => 'articles',
'where' => "publishDate >= '".mysql_escape(@$_REQUEST['publishDateMin'])."' AND publishDate <= '".mysql_escape(@$_REQUEST['publishDateMax'])."'",
));

Hope this helps get you started
---------------------------------------------------
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] url search & search engine by date range

By markr - July 19, 2011

Works. Thanks!