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?
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,
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/
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 18, 2011
E.g., I need a url search to do the following:
listViewer.php?publishDate (between 8/2010 and 7/2011)
listViewer.php?publishDate (between 8/2010 and 7/2011)
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:
Hope this helps get you started
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/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/