There is a way, you use the array syntax to get at a specific value in the query. Someone already posted about how to do this: #myQuery['myColumn'][rowNumber]#.
To be clear, you don't want to condense your work into a couple of databases. You want to normalize your single database to keep the data in the proper tables. Right now you are proposing having separate tables for every course. So that means every time a course gets added, you have to go in and actually create a table, indexes, primary keys, and all the rest? That is extremely inefficient and will absolutely not work over the long term. So good luck with your study of database design, it's actually pretty interesting and is something that will be useful knowledge for a very long time. On 8/10/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. > > > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285962 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
