You could do this two (at minimum) ways. One is to add the db content to your Verity collection. Then you can just search the Verity collection.
Another option would be to perform both searches and join them using QofQ. The main problem you would have (I think) is sorting, as Verity returns a score. Although I believe if you use full text searching in SQL Server (or MySQL) you can get a score value as well. How well it meshes w/ Verity's score is another matter. On 10/29/07, Jeff Gladnick <[EMAIL PROTECTED]> wrote: > Our jobbank program needs an upgrade. Currently, the resumes are pasted into > FCKeditor and stored in a database in HTML format. However, this doesn't > seem to be getting the job done, and we've received a deluge of complaints > and demands for the ability to just upload a pdf/word document. > > Here's how the search results work now: > > http://www.producejobsource.com/index.cfm?event=SearchUsers&query=sales&x=0&y=0&submit=&location=&jobtype=&radius=&school= > > I've made collections before and its no big deal, but I've never had to > combine it with a SQL search too. > > Basically, I need to upgrade my resume search program from a strict SQL > search based on "like'%string%" to one that combines SQL searchs with > searches on a directory full of word and PDF documents and is somehow able to > link those documents back to a user, and then display the search results in > exactly the same way it currently does. > > Has anyone done this before and can you give me some pointers or some code to > look at ? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
