CFDBINFO Returning ALL Datasources

Today I have been left slightly confused about the CFDBINFO tag. According to the Adobe documentation CFDBINFO lets you retrieve information about 'a' datasource, including details about the database, tables, queries, procedures etc, and this is true. Cool, as at the moment I am building an application to backup my user database.

I noticed it also seems to return a list of ALL the datasources including all datasources on another SQL sever we have in our cluster.

There is no security issue, it seems to be 'read only' and I need the username and password to get any information on the other tables.

There does not seem to be any information on this in the documentation.

Aug19

Post Info

Comments 2

[Add Comment] [Subscribe to Comments]
  1. Sam Nicholson's Gravatar # Posted By Sam Nicholson
    01/10/08 12:43

    How is your DB backup app going?

    I started building something similar they other day which was just a CFC with a bunch of methods for creating the database and table constructors as well as keys and insert statements which it then writes to file. I made the point of building it without using CFDBINFO because I didn't want it to be CF8 specific.

    The problem with it so far is that it will only work for MySQL so I got to do some research into some other DB SQL commands.

    Have you managed to get a multi DB type backup running?

  1. Glyn's Gravatar # Posted By Glyn
    01/10/08 14:02

    No sorry not yet, I spotted your post on doing this without CFDBINFO actually. Some of my clients are not on CF8 servers so it would very helpful. I will take another look and post a comment. My backup system was based on Raymond Camden http://www.databasepronews.com/databasepronews-51-...

[Add Comment]