If you just cfdump the service factory, u can see it's methods and functions etc. You can then recurse over them and cfdump them too.
<cfdump var="#request.sqlexecutive#"> <cfdump var="#request.sqlexecutive.datasources#"> -- Russ -----Original Message----- From: Beru [mailto:[EMAIL PROTECTED] Sent: 19 October 2005 17:17 To: CF-Talk Subject: Re: How to batch a change of DSNs Yeah, well let's say the "crappy" statement was just to attract some light ;-)) I'm still with 6.1, heard about the "ServiceFactory" but don't know where to begin with to learn using it... It would be very handy to be able to query/update DSNs, ala sql... Any ideas? On 19/10/05, Jim Davis <[EMAIL PROTECTED]> wrote: > > > -----Original Message----- > > From: Beru [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 19, 2005 4:49 AM > > To: CF-Talk > > Subject: How to batch a change of DSNs > > > > Hello, > > > > Yesterday I was requested to change a couple (~25) of server names > > in DSNs. > > I didn't want to lose my time through the "crappy" (non-practical) > > admin interface, so of course I went on doing a search/replace in > > "neo- query.xml", which works our fine, except that I had to stop > > the server while doing > the > > search/replace. > > > > Is there a less invasive way (without stopping the server) of > > performing this kind of work? > > Are you on CF 7? > > The admin interface (which really isn't crappy you know) is really > just a CF application. The CFC's which provide the services for it are > exposed via the admin API - look it up at > livedocs.macromedia.com<http://livedocs.macromedia.com> > > Using the API you can script the vast majority of admin changes. > > Jim Davis > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221502 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
