Creating a Search page
6 posts by 2 authors in: Forums > CMS Builder
Last Post: July 13, 2010 (RSS)
By dsternalski - July 11, 2010
I've added a search form onto the site and have made it so that when you search for your keywords, it's goes to the search page. However, are you able to help me with the code that searches the table and displays the relevant information?
please find attached the code with the search panel and the listview page.
Re: [dsternalski] Creating a Search page
By Jason - July 12, 2010
Can you tell me which fields in the "contact" table you are trying to search on?
Let me know and I can help you build the appropriate "WHERE" clause.
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] Creating a Search page
By dsternalski - July 12, 2010
This is a search for the whole of the site. I just grabbed one of the pages so that i had the template already.
Re: [dsternalski] Creating a Search page
By Jason - July 12, 2010
Okay, could you let me know exactly what you're searching for?
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] Creating a Search page
By dsternalski - July 13, 2010
The search will be used to search all of the site, so when a user adds a word into the keyword search, a page then appears with the results.
Re: [dsternalski] Creating a Search page
By Jason - July 13, 2010
CMS Builder is used to search for records and fields that are inside the database, and doesn't come setup by default to do site wide searches.
I think you may be looking for something like a google site search. Take a look at this:
http://www.google.com/sitesearch/#utm_campaign=en&utm_source=en-ha-na-us_ca-sk&utm_medium=ha&utm_term=site%20search
Let me know if you have any other questions.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/