You might want to look at my QuerySim tag if you're going to be doing a lot
of those. It's at www.halhelms.com.
Hal Helms
Team Allaire
[ See ColdFusionTraining.com for info on "Best Practices with ColdFusion &
Fusebox" training ]
-----Original Message-----
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 6:16 PM
To: Fusebox
Subject: Re: "fake" query
Those functions allow for the creation of a query data type without having
to run a CFQUERY.
QueryNew will create the query with the cells you want. QueryAddRow will add
a new row to the query and QuerySetCell will set data to the cells in the
row.
> Eron,
>
> I'm about to start using your very appreciated reply below to build a
search
> app. Could you explain a little more about #3) below: "Make a "fake"
query
> useing Querynew, QuerySetCell,
> and QueryAddrow"-or point me somewhere that explains the concept?
>
> Thanks,
>
> Tom
>
> -----Original Message-----
> From: Eron Cohen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 01, 2001 11:37 AM
> To: Fusebox
> Subject: RE: Verity
>
>
> Tom,
>
> (forgive my paste-age)
>
> One way to do it is:
>
> 1) Keep a list of fuseactions in a database table
> (this is something I do by default)
> 2) Loop through the fuseactions and use CFHTTP to grab
> the pages that result from each fuseaction
> 3) Make a "fake" query useing Querynew, QuerySetCell,
> and QueryAddrow.
> 4) Use CFINDEX to index the fake query, the key or a
> custom field is going to be the fuseaction so that
> when someone searches, they can be dumped back to the
> correct fuseaction.
>
> Because this can be a slow process, you might want to
> use some kind of timestamp to keep track of what pages
> have been updated and which ones not. Only index the
> ones that have not been updated "Recently"
>
> There are other ways to do it, but this is one, and it
> does work.
>
> Eron
>
>
> -----Original Message-----
> From: Tom [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 01, 2001 2:00 PM
> To: Fusebox
> Subject: Verity
>
>
> So, has anyone developed a solution for the Verity
> issue? I went and built a
> fuseboxed app and now I'm in trouble cuz I can't build
> a search for it. I
> noticed a search app built in fusebox in the Allaire
> developer exchange.
> Does it solve the problem?
>
> -Tom
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
