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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Requery of a query in CF 4.5?
oi Shawn!! nope. 5.0 & above.. -- Critz Macromedia Certified Advanced ColdFusion Developer http://blog.ctzc.com";> Thursday, November 14, 2002, 12:09:08 PM, you wrote: SR> Hello, SR> Can you requery a query in Cf 4.5? I can't seem to find anything in the Docs SR> about it. SR> Any help would be great :) SR> TIA SR> Shawn Regan SR> pacifictechnologysolutions SR> 15530-B Rockfield Blvd. Suite 4 SR> Irvine, CA 92618 SR> 949.830.1623 SR> w w w . p t s 1 . c o m SR> ~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Requery of a query in CF 4.5?
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
RE: Requery of a query in CF 4.5?
I guess I could dump the recordset into a structure and then pull out only the lastest recordset that way. 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Requery of a query in CF 4.5?
Shawn Regan wrote: > 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. So do it programmatically on your output... You could try using MAXROWS="1" on the INNER statement. If that doesn't work, simply do this. some stuff output the row You would use "somecriteria" to have it display all rows for certain groupings. - Rick ~| 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
RE: Requery of a query in CF 4.5?
Yes, thanks I did one more group output and used maxrows and it worked fine. Thanks 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: Rick Root [mailto:rroot@;wakeinternet.com] Sent: Thursday, November 14, 2002 10:46 AM To: CF-Talk Subject: Re: Requery of a query in CF 4.5? Shawn Regan wrote: > 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. So do it programmatically on your output... You could try using MAXROWS="1" on the INNER statement. If that doesn't work, simply do this. some stuff output the row You would use "somecriteria" to have it display all rows for certain groupings. - Rick ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.