Hello all, I'm having a issue w/ Verity. It's not a huge problem, but i imagine there is a cleaner solution.
I have two tables: attorney & bio in bio, there is attorney_ID which is a Foreign Key to attorney, so attorneys can have multiple bios. I want in verity, to index one attorney_ID and then *all* rows in bio that correspond to that attorney_ID. A good comparison would be (in SQL) to group by attorney_ID and *concatenate* (i wish) the bio fields as a new field. Is there anyway to "append" values to the body of a verity Index? - jim ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

