Looking for a gem that can do full-text-search of active-record tables

Hi All,

I have a table of 500! entries that needs to be used as a pick list, or a selection list. 500 entries is way overkill for a selection list, so I am looking for a gem/plugin that can search across stipulated fields of an AR table or tables.

Any help is appreciated.

have a look at thinking_sphinx

http://freelancing-god.github.com/ts/en/

You will need sphinx installed and running but will easily wire up your AR tables as a search index

Adam