you can do <cfdump var="#dsFull['dbname']#">
to get the sub structure, if I understand your question. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -----Original Message----- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 8:54 AM To: CF-Talk Subject: Mental Block - Structures and CFDUMP I've been playing again with the coldfusion.server.ServiceFactory object and I've run into a little bit of a mental block. I CFDUMP a specific piece and I'm returned: STRUCT cfsnippets STRUCT driver ODBC Socket How do I get to the Struct within in the struct? I want to be able to output the contents of DRIVER. This is the code I'm using to get to here: <CFOBJECT ACTION="CREATE" TYPE="JAVA" CLASS="coldfusion.server.ServiceFactory" NAME="factory"> <cfscript> dsService=factory.getDataSourceService(); dsFull=dsService.getDatasources(); dsNames=StructKeyArray(dsFull); </cfscript> <cfdump var="#dsFull#"> I can loop over the dsNames array and get the Datasource Names, but how do I get into the structure located beneath the datasource names? I'd like to be able to display ONLY SQL SERVER results, not Access or MySQL or ODBC, just SQL Server. Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net <http://www.garrisonenterprises.net/> [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] ************************************************************************ ************* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

