Page 1 of 1
Search - Extending the search to other tables in the database
Posted: Tue Feb 16, 2010 9:58 pm
by paul
I developed an application that uses my own database tables. The application runs within a CMS Made Simple framework. Now we want the site's (CMS Made Simple's) search to also look into these new tables.
How do I go about in doing this?
Can someone make a guess as to how long this would normally take?
I imagine this is quite a common task.
Thanks,
Paul.
Re: Search - Extending the search to other tables in the database
Posted: Tue Feb 16, 2010 10:35 pm
by Jeff
No, this isn't a common task.
Time depends on how you have it implemented, the best solution is to copy the functions and calls in a module like News/CGBlog and others of how they enter the word into the search table and retrieve the results. It could range from 2hrs to 20hrs or more.
Re: Search - Extending the search to other tables in the database
Posted: Tue Feb 16, 2010 10:45 pm
by paul
So the CMS Made Simple is looking in a specifc "Search" table? I assume this is an index compiled of other tables in the CMS Made Simple somewhere? (I assume that CMS Made Simple does it this way)
If so then it would be a simple matter make a DB trigger to update this index with my own data?
Thanks,
Paul.