Verity: more than 4 columns?

[Loony2nz]

Hello,

I've been tasked recently to add a search engine to an internal project and this is my first foray into Verity with CF.

I've seen all the examples on the web regarding how to add a query to an index. But, what I've seen is that I can only index 4 columns (Custom1-4).

I have a table with about 20 columns that I would like to add to the search index. How do I add more than 4 columsn to the index?

Thank you!

[Newsgroup_User]

Perhaps a closer inspection of the docs might help:
http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000278.htm

You can specify a QUERY attribute, and when doing so the BODY attribute is
a list of the columns in said query to index.

--
Adam

[Loony2nz]

Thank Adam, but what the BODY attribute does is lumps all those fields into one field, "summary". This doesn't fit with what I'm trying to do. Here's an example.

table structure (scaled down of course)
ID, fname, lastname, email, manager_fname, manager_lname, dept.

I would like to index all of those items, so that when someone types in the search box (google-style), "John", I get all the rows that contain "*john*" within the index.

a sample return would be:
ID fname lname email manager_fname manager_lname dept
3 john jones jjones fred hicks marketing
4 jack smith jsmith john jones sales

any idea?

[Newsgroup_User]

> I would like to index all of those items, so that when someone types in the
> search box (google-style), "John", I get all the rows that contain "*john*"
> within the index.
>
> a sample return would be:
> ID fname lname email manager_fname manager_lname dept
> 3 john jones jjones fred
> hicks marketing
> 4 jack smith jsmith john
> jones sales

OK, just because that's what Verity returns as its default summary doesn't
mean you have to use that in your display. It also returns the key of the
record, which you can then use to do a select query from the DB to return
columnar data.

But to be honest, I'd not use Verity for this sort of thing. I'd just use
a DB query in the first place, or hasve a look at what the full-text
searching capabilities of your DB offers.

--
Adam