Creating a Search page

6 posts by 2 authors in: Forums > CMS Builder
Last Post: July 13, 2010   (RSS)

Hi,

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

Hi,

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: [dsternalski] Creating a Search page

By Jason - July 12, 2010

Hi,

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

Hi,

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

Hi,

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/