Ahhh, thought you meant you wanted it to append some results (without losing old results). So you want it to actually APPEND to an existing entries body? Ouch... I don't think your going to get that.
I'd try breaking things up into their own collections to not only speed things up, but easily give you the option of searching ONLY certain sections. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Greg Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 7:46 AM To: CF-Talk Subject: Re: Verity Help Ya, thats what we are using, but it updates by replacing the body not appending to it. >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226544 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
