> 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? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236262 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