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:296471
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4