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