Is it a SQL error, or a CF error? Because it could be CF not liking having a query return multiple columns with the same name (SELECT t1.name, t2.name), because query objects can't deal with that.
That's a total WAG, as I don't use SQL Server, the Data Direct drivers, or much of CF7 (just one server of 14), but thought I'd throw it out there. cheers, barneyb On 8/9/05, jonese <[EMAIL PROTECTED]> wrote: > Has anyone else encountered a rash of " Ambiguous column name" errors > cropping up in CF7 that you didn't get in CF6.1 or CF5? > > We have a MS SQL 2000 backend and our CMS was recently upgraded and ported > to CF7 from CF6.1. Since moving to CF7 a lot of our scripts are breaking due > to " Ambiguous column name" errors which we never encountered in previous CF > versions. > > Am i missing a configuration setting or did the major leap in DataDirect > dirvers versions bring this bug to the surface. > > And yes we know that it's bad to not referance the columns as > tablename.columnname but in our system some things are just too dynamic to > do this at this time. > > Ideas? thoughts? solutions?? > > jonese > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:214198 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
