I ran your code with a couple of DSNs of my own on CF8.0 and it displayed the table info for each of the different databases.
The first dump output is repeated though. Adrian Building a database of ColdFusion errors at http://cferror.org/ -----Original Message----- From: Dan LeGate Sent: 22 October 2008 21:15 To: cf-talk Subject: cflooping over cfdbinfo giving me funky results When I use the code below to try to see information about both Datasource1 and Datasource2, it always ONLY shows me info on the FIRST data source in the list (Datasource1). Is this a looping logic problem, or something to do with running cfdbinfo too quickly over and over? Even if I reverse the list and put Datasource2 first, it only shows me info on Datasource2, and repeats Datasource2's information when Datasource1 is "ThisDSN". <cfloop index="ThisDSN" list="Datasource1,Datasource2"> DSN = <cfoutput><strong>#ThisDSN#</strong></cfoutput><br> <cfloop index="ThisType" list="dbnames|tables|version|procedures" delimiters="|"> Type = <cfoutput><strong>#ThisType#</strong></cfoutput> <cfdbinfo datasource="#ThisDSN#" name="result" type="#ThisType#"> <cfdump var="#result#"> </cfloop> <HR> </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
