Good catch, Mike. I knew that too and either it didn't occur to me or I forgot to mention it... I think it falls into the category of things that I sort of assume have already been checked.
> What if the problem isnt the table name but the owner > name? > I've had similar issues, and replaced SELECT * from > dbo.tecSOLine > with SELECT * from tecSOLine > IF that works where the other doesnt, then you probably > need to either > change your query code, or change the object owner. Look > in Books Online > for how to do it for your database, but in SQLServer2000 > there's a SP you > use as follows: > exec sp_changeobjectowner 'dbo.secSQLine', 'otherlogin' > Cheers > Mike Kear > Windsor, NSW, Australia > Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > On 3/28/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: >> >> > I assume SQL Server's "Invalid object name" error is >> > typically a result of a >> > missing table or mistyped table name. But I'm seeing >> > it >> > at a rather odd >> > time. >> >> > When I run a certain query as part of a CFC function, I >> > receive the error >> > "Invalid object name 'dbo.tecSOLine'". But if I pull >> > the >> > offending query >> > out of the CFC and run it independently, it works as >> > expected. CF seems to >> > know the table exists, otherwise it wouldn't work in >> > any >> > situation, which >> > leaves me puzzled. >> >> > Are there other common causes of "invalid object name" >> > errors that any of >> > you have run across? >> >> I've seen it throw that error on a view that contains >> reference to a >> deleted table, but that doesn't sound like what you're >> experiencing. >> >> >> s. isaac dealey 434.293.6201 >> new epoch : isn't it time for a change? >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236275 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
