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> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:214203 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
