You tried action="update" ? ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com
-----Original Message----- From: Greg Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 07, 2005 2:57 PM To: CF-Talk Subject: Verity Help Ok, I have a database with 35 tables in it. I need to index fields from each of the tables so that it can all be searched and return the record numbers to pull out all the details. But bringing back every record with 35 tables joined takes so long things time out. So my plan was to query a table, add it to a collection, then do the next and add it to the same collection. IOW each query appends to the body field of 1 collection with seperate cfindex calls. However each time I use an index statement, it erases what is curently there. Any ideas other them building the body in a variable or file and then indexing that? Thanks Greg ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
