I have a query that I run which is dumping out in a grouped query. But I have one group that I need to only display the most recent recordset, but the other two groups need to display all recordsets. SO I cannot apply my logic in the SQL because it would affect all three groups.
Shawn Regan pacifictechnologysolutions 15530-B Rockfield Blvd. Suite 4 Irvine, CA 92618 949.830.1623 w w w . p t s 1 . c o m -----Original Message----- From: Stephen Moretti [mailto:stephen@;cfmaster.co.uk] Sent: Thursday, November 14, 2002 9:19 AM To: CF-Talk Subject: Re: Requery of a query in CF 4.5? Query of Queries is in CF5.... What are you actually trying to do? If the information is in one datasource, then you will be able to sort this out with a single SQL query. Regards Stephen ----- Original Message ----- From: "Shawn Regan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 14, 2002 5:09 PM Subject: Requery of a query in CF 4.5? > Hello, > > Can you requery a query in Cf 4.5? I can't seem to find anything in the Docs > about it. > > Any help would be great :) > > TIA > > Shawn Regan > pacifictechnologysolutions > 15530-B Rockfield Blvd. Suite 4 > Irvine, CA 92618 > 949.830.1623 > w w w . p t s 1 . c o m > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
