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? Thanks, paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236244 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
