Verity: more than 4 columns?

> 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

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?

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