Two options here: 1. you either to the cfquery and do one single query and have one resultset.
With this you simply to a: <cfindex action="update" query="qry" collection="yourcol" key="classified_id" body="fieldnames"> 2. you query your tables and got 4 resultsets and then do for each a index but use the categorytree to "combine" them like; <cfindex action="update" query="qry" collection="yourcol" key="maintable_id" body="fieldnames" categorytree="classified_id"> <cfindex action="update" query="qry" collection="yourcol" key="detailstable_id" body="fieldnames" categorytree="classified_id"> etc. Hope this helps and makes sense :-) Kind Regards, Nitai On Tue, Sep 29, 2009 at 7:16 PM, Jason Allen <[email protected]> wrote: > main table > details table > features table > photos table > > Using CFINDEX, I would create a collection, called "aircraft > classifieds". I would populate the key field with the "classified_id" > and the body with all the relevant columns from ALL the tables. If a > search matched any of those fields, it would return the KEY, which is > the classified_ID, and I could then go fetch the actual records using > that classified_id. -- Razuna SaaS On-Demand - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Follow us on Twitter http://twitter.com/sixsigns --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
