I am trying to implement Verity Search in a project I’m working on. I have to start by saying that my knowledge about this subject, is very basic, I.E. I know how to create a collection either in the Administrator or by using the <cfcollection> tag. I known how to index, update, delete, purge, or refresh a collection and I know how to search a collection with the <cfsearch> tag, but that’s about it and this is obvious not enough for what I would like to accomplish, since I’m breaking my head over this for the last few days :headbang:
The situation is this; I’m working on a website covering activities in the Peloponnese, Greece. My main pages and related db tables are; categories.cfm (table:categories), activities.cfm (table:activities), cities.cfm (table:cities) and companies.cfm (table:companies). The content on all four pages is completely dynamic. As you understand all tables are related to eachother, I.E. the category water sport has several activities (scuba diving, water skiing, etc.), there are several companies offering water sport etc.
What I would like is that when someone using the search string scuba diving, that the result page returns everything related to scuba diving, in other words:
<!-- link to the activities page scuba diving, coming from the database -->
<a href="http://www.websitename.com/activities.cfm?id=#94#">#title#</a>
<!-- links to the companies page, with companies offering scuba diving. This is just one page with content is coming from the database depending on the id -->
<a href="http://www.websitename.com/companies.cfm?id=#150#">#title#</a>
<a href="http://www.websitename.com/companies.cfm?id=#350#">#title#</a>
<a href="http://www.websitename.com/companies.cfm?id=#1320#">#title#</a>
Another example could be, that if someone used the search string Archaeological Sites, the following results should be returned:
<!-- link to the activities page Archaeological Sites, coming from the database -->
<a href="http://www.websitename.com/activities.cfm?id=#2#">#title#</a>
<!-- links to the cities pages, that have the search string Archaeological Sites in the content (coming from the database), which is not unusual in Greece ;) -->
<a href="http://www.websitename.com/cities.cfm?id=#1#">#title#</a>
<a href="http://www.websitename.com/cities.cfm?id=#2#">#title#</a>
<a href="http://www.websitename.com/cities.cfm?id=#3#">#title#</a>
I spent the last two nights browsing the Internet to find some useful information, and maybe it’s me, but I find the documentation covering the subject very limited. Most of the articles are very clear in the beginning but when it comes to the point where things become complicated they finish it off with just a few lines.
Some articles mention that you can’t use the normal Verity Search but you need vSpider instead. I find it all very confusing. Can someone please point me in the right direction how to set something like this up or where I can find a detailed tutorial covering this subject.