~scratches head~ Right.....
I suspect that you don't actually need to JOIN your queries together for indexing into a collection. There is probably one or two text fields in one of the queries right? When you add a new record to that table (or when the record is marked as visible to the outside world) then you need to use CFINDEX to add it to the verity collection. When you delete (or mark it invisible) a record then you need to use CFINDEX to delete it from the collection. When you change the content of those text fields then you need to use CFINDEX to update your verity collection. quick example using a news article as an example <!--- Previously insert and get the new ID for a News Story, then get all the details gathered in a query ---> <cfquery name="myNewStory" datasource="myDSN"> SELECT NewsID,Headline,BodyText,ImageCaption FROM NewsStory WHERE NewID = #MyNewNewsID# </cfquery> <!--- Now Insert/Update the verity collection from the query ---> <cfindex action="UPDATE" collection="NewsCollection" key="NewsID" type="CUSTOM" title="Headline" query="myNewStory" body="Headline,BodyText,ImageCaption"> When you do a CFSEARCH one of the items that is returned as part of the query object is the key that you used in the cfindex. With this information and the other stuff you get back from a CFSEARCH (RTM) you'll be able to produce a list of all the record that match the users search criteria and provide links to the full display. I suggest you have a good read through the docs on verity in CFStudio, the books/online docs that came with CF Server or any good CF book. (Mastering CF 5 is a very good book.... I would highly recommend it... Haven't looked at Mastering CFMX yet...) Hope that helps to get you started. Regards Stephen ----- Original Message ----- From: "Dowdell, Jason G" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 15, 2002 4:36 PM Subject: RE: Verity index of a query > I have two tables I'm pulling together in a query result set. > I need to know what I have to do in order to make sure that > the current results of the query are the same as is in the > collection. I think I have to update the collection but > that's my question. > > ~Jason > > -----Original Message----- > From: Stephen Moretti [mailto:stephen@;cfmaster.co.uk] > Sent: Friday, November 15, 2002 10:24 AM > To: CF-Talk > Subject: Re: Verity index of a query > > > > My application is basically a search engine. So whenever new sites > > are added I'm assuming that I won't have to recreate or update > > the verity index since it's based on a query... I just want to > > make sure that when they search the index they're getting everything > > back from the db as it currently stands. > > > > Let me know if I'm off base here. > > > Ummm... Yeah you are a little off base... > > What is it that you actual want to index and to allow people to search? > > Stephen > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
