Thanks for the input ...
I am joining tables in the query ... but the original query which indexes
the data just fine is exactly the same and also uses joins.
Can you remember where in the book is the reference about "master/servant"
relationships?
Thanks
Steve
> -----Original Message-----
> From: Jason Blum [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 7:49 PM
> To: CF-Talk
> Subject: Re:RE: Verity & SQL
>
>
> Hmmm...
>
> I don't know - because I have been able to do just what you are
> describing. My
> first suspicion is whether you are accidentally refreshing a different
> collection than that which you are searching? (Don't get me
> wrong - this is
> just what I did last week and spent all day mystified by it)
>
> The other two things I am thinking are did you just add data to
> existing columns
> or did you perhaps create a new column and then not tell CFINDEX
> about it or
> what to do with it?
>
> And then the third thought is are you joining tables? - because there was
> something in the book about indexing data from two tables which have a
> master-servant relationship (I know the word is not servant - just can't
> remember)
>
> -J
>
>
>
> ____________________Reply Separator____________________
> Subject: RE: Verity & SQL
> Author: [EMAIL PROTECTED]
> Date: 6/13/01 6:03 PM
>
> Hi Jason,
>
> Thanks for the help. This is a great solution - which I've already tried
> (also from pg 733 :-) ... but to no avail.
>
> Basically, I've inherited a database from an existing site and
> when I index
> the data everything works fine. Then when I add new records and re-index,
> they are not included. The query that I use to get the data I
> want to index
> has been tried in SQL query analyzer, and the new records show up
> - so they
> *should* be included in the indexing.
>
> I've tried absolutely everything - but nothing seems to work.
>
> So now I'm trying to combine my standard SQL query with another Verity
> query, without having to create a Verity collection from the
> database query.
>
> Dave Watts has suggested "building a query object using the CF query
> functions, and populating the query by looping over the two source
> queries" - but as he suggested, this may be too slow.
>
> DOH!
>
>
>
>
>
>
> > -----Original Message-----
> > From: Jason Blum [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 4:52 PM
> > To: CF-Talk
> > Subject: Re:Verity & SQL
> >
> >
> > Steve!
> >
> > Finally something I can contribute to this wonderful list!
> >
> > I am in fact working right now on the code to do just this.
> >
> > I am assuming you already have a Verity collection with SomeName.
> > Then you need
> > to make a kind of on-the-fly collection out of a normal db query
> > and call it
> > Dbquery
> >
> > So on the search page, here is your Dbquery:
> >
> > <!--Retrieve data from Db for onthefly collection-->
> > <cfquery name="GetSomeData" datasource="YourDatasource">
> > SELECT Field1, Field2, Field3, Field4
> > FROM SomeTable
> > </cfquery>
> >
> > <!-- Now convert this data into a collectionto be queried with
> > GetResults next
> > page-->
> > <CFINDEX ACTION="refresh"
> > COLLECTION="OntheFlyCollection"
> > KEY="Field1"
> > URL="Field2"
> > TYPE="custom"
> > TITLE="Field3"
> > BODY="Field4"
> > QUERY="GetSomeData">
> >
> > Then on the search results page,
> >
> > <cfsearch
> > name = "GetResults"
> > collection = "SomeCollection, OntheFlyCollection"
> > criteria = "#Form.Criteria#">
> >
> > And that's it. Two things to note, you actually have to create a
> > collection
> > called OntheFlyCollection first, so that you can be refreshing it
> > here on the
> > search page.
> >
> > Also, notice that in the <CFINDEX> you are telling Verity which
> > fields should be
> > considered what Verity values, so Field2 is your URL for instance
> > - kind of
> > limiting, but don't forget you can make two custom tags!
> >
> > HOpe this helps - got it all from p.733 of Forta and
> > http://www.cfug-md.org/articles/verityvsslicedbread_final_draft.cfm
> >
> > -Jason
> >
> >
> > ___________________Reply Separator____________________
> > Subject: Verity & SQL
> > Author: [EMAIL PROTECTED]
> > Date: 6/13/01 4:00 PM
> >
> > Is there any way to combine the results of a CFSEARCH and a standard SQL
> > search into the same CFOUTPUT ... basically merge two queries?
> >
> > Thanks
> > Steve
> >
> >
> > Development Manager
> > Vardus Internet Solutions (SA)
> >
> > Tel: (+27) 21 670 9880
> > Fax: (+27) 21 674 4549
> >
> > Email: [EMAIL PROTECTED]
> > Website: www.vardus.com
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
