Using WHERE clause with Search
5 posts by 3 authors in: Forums > CMS Builder
Last Post: March 9, 2009 (RSS)
By pothompson - March 8, 2009
Currently, I can get the search working, but as soon as I add a WHERE clause, that's the only thing that seems to be used when displaying the results.
Thanks - Paul.
Re: [pothompson] Using WHERE clause with Search
By gkornbluth - March 9, 2009
The where clause can limit the results of a search in many ways, like limiting the search results to only those records where a particular field starts with, or contains particular values. Say, when you'd only want to search within a particular category of items.
You might find the explanations on this and other topics in my CMSB Cookbook helpful.
Best,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [pothompson] Using WHERE clause with Search
By Dave - March 9, 2009
Both the where and the search code should both apply. Which version of CMSB are you using?
interactivetools.com
Re: [Dave] Using WHERE clause with Search
By pothompson - March 9, 2009
I'll try again, I expect I've made some mistake.
Paul.
Re: [pothompson] Using WHERE clause with Search
By Dave - March 9, 2009
Hope that helps!
interactivetools.com