Michael,
Hmmm... I think you may be right - however, the onthefly collection is not
aptly named because in fact, the collection is just refreshed (based on the SQL
query) every night and unless the db has been significantly modified, there's no
reason to refesh it again throughout the day.
As for maintaining it, couldn't I just have all the code for refreshing in some
page that gets HTTP requested in Administrator's scheduled tasks?
-J
____________________Reply Separator____________________
Subject: Re: Re:Verity & SQL
Author: [EMAIL PROTECTED]
Date: 6/13/01 6:52 PM
Won't work with multiple users seaching on the same time because of the
collection "on the fly"
creation latency - both trying to use OntheFlyCollection which is alright
(for the first user) at second
number 1 but it's not updated for second user (or first user, depending who
run what and where
first...)
but If you can create a collection that will sure to be unique, again -
ontheflyCollection,
it might work, but will involve some major maintance..
again, I personally don't see any point nor success to this.
Thanks,
Michael
----- Original Message -----
From: "Jason Blum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 4:52 PM
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
