Is the owner the same for all the tables? How about querying the db
directly:
SELECT * FROM INFORMATION_SCHEMA.TABLES
Besides the point I know, but it looks like that will get you exactly the
same data.
Dominic
On 12/01/2008, Sonny Savage <[EMAIL PROTECTED]> wrote:
>
> Perhaps it has to do with SQL compatibility settings on the databases
> themselves?
>
> On Jan 12, 2008 6:49 AM, Adrian Lynch <[EMAIL PROTECTED]> wrote:
>
> > Morning all, I have the following:
> >
> > <cfdbinfo type="tables" name="tables" datasource="aDatasource">
> >
> > It returns tables for some datasources but not for others. It seems to
> be
> > on
> > newer tables that it fails to return data (I get an empty query).
> >
> > Comparing a working to a non working one in cf admin shows no
> difference.
> > I've also compared the datasources with:
> >
> > CreateObject("component","cfide.adminapi.datasource").getDatasources()
> >
> > There doesn't seem to be a difference in these details either.
> >
> > The DB is SQL 2000 and CF is 8.
> >
> > Can anyone offer up an explanation for this, I'm not sure what to try
> > next.
> >
> > Adrian Lynch
> > http://www.adrianlynch.co.uk/
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296472
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
