Query of Queries Functions
Is there a way to do SQL Updates and Deletes on record sets organized as Query of Queries? It seems that only SELECT works. I'm using CF8. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query of Queries Functions
On Thu, Feb 26, 2009 at 5:56 AM, Ron Gruner webmas...@gruner.com wrote: Is there a way to do SQL Updates and Deletes on record sets organized as Query of Queries? It seems that only SELECT works. I'm using CF8. A query of queries does not make a connection to the actual database. It is only a way to further filter previously retrieved record sets. So no, you cannot do updates or deletes. -- Matt Williams It's the question that drives us ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query of Queries Functions
Thanks Matt. Is there some other way to build a small and temporary database that resides in RAM and can be manipulated with all, or most, SQL functions? I suppose Structures is the best approach but they're new for me. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query of Queries Functions
On Thu, Feb 26, 2009 at 6:35 AM, Ron Gruner webmas...@gruner.com wrote: Thanks Matt. Is there some other way to build a small and temporary database that resides in RAM and can be manipulated with all, or most, SQL functions? I suppose Structures is the best approach but they're new for me. Yes, you could do structures or an array of structures. If temporary is all you need and not actual database persistence, you can work with the query result set also. You can manipulate data in that with QuerySetCell. You can also add rows and columsn with QueryAddRow and QueryAddColumn. Check the docs for actual usage and examples. -- Matt Williams It's the question that drives us ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query of Queries Functions
There's no obvious way to delete a QofQ row. Am I missing something? Thanks again. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query of Queries Functions
Although you can't DELETE a record from a QoQ, you can SELECT all other records and save them into the same QoQ variable. In other words, instead of removing the unwanted records, just select all of the wanted records. Thanks, Mike -Original Message- From: Ron Gruner [mailto:webmas...@gruner.com] Sent: Thursday, February 26, 2009 8:23 AM To: cf-talk Subject: Re: Query of Queries Functions There's no obvious way to delete a QofQ row. Am I missing something? Thanks again. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query of Queries Functions
Cool. The help is really appreciated. What a great resource. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4