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
