It's not really that difficult: http://www.cflib.org/udf.cfm?ID=117
======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Ilyinsky, Igor [mailto:igor.ilyinsky@;csfb.com] > Sent: Wednesday, November 06, 2002 5:27 PM > To: CF-Talk > Subject: RE: CFC - Returning a Query Subset > > > Thanks Ade, > > But, the entire query is a full search, with tons of clauses. > So I can't sort by ID, and I can't just pick up the TOP > #rowCount# results. I need a SQL compliant query (as the DB > may change, currently Access) and I need to return only the > necessary subset to the cfc caller. > > I'm trying to avoid copying/parsing into a new Query Object, > as this is a huge pain in the a**; unless someone has a cool > utility for this. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
