Well, if it's happening in Query Analyzer, then it's not CF that's causing the problem. CF's not in the mix at all at that point. Did your SQL server get patched without you knowing or anything?
cheers, barneyb On 8/9/05, jonese <[EMAIL PROTECTED]> wrote: > 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 > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:214205 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
