I don't know of a custom tag, but if you use Query functions, you can fake
it.
Use QueryNew(myCFQUERY.columnlist) to create a new query object.
Then iterate through your CFQUERY and check for whichever values you want.
You can get clever by using valueList on your CFQUERY object to create
lookup lists; you could then get a listposition from the lookup list, and
use that as the startRow attribute for a CFOUTPUT of your created query
object.
<grin> At least, it sounds like it should work. It's hard to suggest the
best solution without knowing the amount of data involved.
Dave
-----Original Message-----
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 4:33 PM
To: CF-Talk
Subject: Anyone know of a custom tag to query a query ?
Hi,
I know this will be included in CF 5.0 but unfortunately that won't be
around soon enough.
Before I haul off and try to write something to do this, does anybody know
of a custom tag that will query a query?
I've browsed through Allaire's tag gallery and while there are a number of
tags that will manipulate queries there's nothing that gets a subset of data
from an existing query.
I'd written a lot code that performed lots of small single queries which
made the data more accessible to me in terms of variable granularity, i.e.
one query name per small query but due to bad performance our DBA
recommended that I reduce the number of queries by being less specific and
parse the data on the CF side.
Thanks,
Kevin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
