Thanks mucho for your advices, I will try these... Anyone here heard of some "alternative" Admin GUI (for the maintenance of DSNs etc)?
On 19/10/05, Snake <[EMAIL PROTECTED]> wrote: > > 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>< > 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:221605 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
