There is a way and someone answered it here in this thread (maybe you missed it):
Assuming you have always one row returned from the query: <cfoutput>#Rate1[time1][1]#</cfoutput> Or, if you have more than one row: <cfoutput query="Rate1"> #Rate1[time1][currentRow]# </cfoutput> Alternatively: <cfoutput query="Rate1"> #Rate1.GetString(time1)# </cfoutput> All these work. But you definately need to heed the previous advice. Dominic On 10/08/07, Zach Firestone <[EMAIL PROTECTED]> wrote: > > Thank you for your suggestions. I will definitely look into condensing my > work into a couple databases. But as far as the problem I had in case I run > into something like this in the future. I take it there is no way to do what > I want in ColdFusion. It seems like this would be something more people > would have run into at some time or another. > > >Yes, seriously, I'll jump right behind Brian here - one schema can > >handle everything you need if properly designed. You're currently > >solving the wrong problem. > > > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285951 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
