Jonese, Has your administrator also upgraded your version of SQL Server by chance? I've gotten this error before in older versions of CF when forgetting to specify a tablename, so I can't imagine it has anything to do with CF7. As far as I know, since the error is generated by SQL, then CF just passes it on to you and doesn't actually do 'anything' with it. Could you have had a CFTRY/CFCATCH around it previously, or some kind of other error exception handling? Something else must have changed.
Dave -----Original Message----- From: jonese [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 1:03 PM To: CF-Talk Subject: Re: CF7 lots of new "Ambiguous column name" issues It is definatly a sql issue because when i copy out the queries and past them into enterprise manager or query analyzer i get the same error. It's not random it happens on the same query on every site which has 2 tables with the same column name (in this case archive). I've changed the query to referance the column as tablename.column name and this has resolved the error for our users but i'm still curious as to why this suddenly started appearing with CF7. an example query would be like so: SELECT #preserveSingleQuotes(CompanyNewsTitle)# AS thisValue, companyNewsid AS thisID, ordinal, ISNULL(active, 1) AS Active FROM companyNews WHERE companynewsid NOT IN (SELECT companynews.companynewsid FROM version INNER JOIN companynews ON version.instanceItemID = companynews.companynewsid WHERE formobjectitemid = 134 AND archive = 1) jonese On 8/9/05, Damien McKenna <[EMAIL PROTECTED]> wrote: > > Is it specific queries or apparently random? Can you post a sample > query? > > -- > Damien McKenna - Web Developer - [EMAIL PROTECTED] > The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 > #include <stdjoke.h> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214204 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