I have the requirment to write a search engine for the cms i am building since i am creating it open source im using llbgen as the dal however i dont see much document how i would go about say searching tblarticles and fields title name content tbl downloads file filename e.t.c

is their an example of using llbgen as a search engine for ur articles in a cms at all

Well you may check the search feature of this forums HnD

It searches in Messages text and/or Threads subject.

I havn't looked at the Hnd code, but as a user of the forum, I find the search in Hnd to be very unsatisfying. By that, I mean, I can't easily find the messages I am looking for.

There is a open source search engine called Lucern (I think). I also don't know how well it works.

Google type search gives good results, I have heard the engine is available to embed in applications.

arschr wrote:

I havn't looked at the Hnd code, but as a user of the forum, I find the search in Hnd to be very unsatisfying. By that, I mean, I can't easily find the messages I am looking for.

There is a open source search engine called Lucern (I think). I also don't know how well it works.

Google type search gives good results, I have heard the engine is available to embed in applications.

This forum uses Sqlserver's full text search, so you can use all full text search commands available, including near etc. They're explained on the search page. It doesn't do wildcard searches by default as these are a bit slower. I think this causes many of your search problems. Could you try with wildcards etc. next time ?

I think you mean Lucene ? (apache). Perhaps it's a bit better than fulltextsearch but it works the same way. Integrating Lucene can be a challenge, full text search is right there in the db, so you can join sets based on fulltextsearch results.