Thank you ... I just tried this: <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#"> ---> <cfoutput>#dsFull.cfsnippets.driver#</cfoutput> And it worked. Thanks for the help! Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. 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 [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 12:00 PM To: CF-Talk Subject: RE: Mental Block - Structures and CFDUMP To output a specific subkey of a structure of a structure, you just use dot notation. ie, if foo is a structure that contains name, a key with a simple value, you could do: <cfoutput>#foo.name#</cfoutput> If foo contained a key called data, a struct itself, and data had a key called name, you would do: <cfoutput>#foo.data.name#</cfoutput> ======================================================================= Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 10: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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.

