>Glad we could help. :) lol!!!
ok i have something s bit harder that i hope you could help with.... i want to get the resultset with the columns ordered correctly and the the column names with the correct case. i have tried using: getQuestionData.getMetadata().getQueryColumnMetaData() or getQuestionData.getMetadata().getQueryMetaData() but i am getting an error saying that these methods dont exist do you have any advice on whether this is possible please thanks richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299538 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
