So, I had and developed an app fine with CFMX 6.1 running Apache 2. I moved it
to a different server and everything pretty much works fine in all the other
apps. Today, I went in to test my app and it can't find a table. Mind you, not
any table just one table. If I modify it to database.owner.table it works fine.
I have had this problem pop up before with CF where it seems to just stop
finding certain random tables in a database unless you explicity say where they
are. Any Ideas? The assist table is the one it couldn't find. Giving me a
'Invalid Object' error. The datasource is setup to go only to that database and
its username can see and play in that database just fine as the dbowner. Is
this just a bug with CF?

Before:
<CFQUERY name="qPeople_Submitted_Current" datasource="TS">
select * from ts.dbo.ts_hdr where
approval_status = 's'
and (jobsupervisor_eid='#get_supervisor(form.eid)#'
or jobsupervisor_eid in (select eid from assist where
ass_eid='#get_supervisor(form.eid)#'))
and period='#form.period#'
ORDER by jobsupervisor_eid, eid, period;
</CFQUERY>

After:
<CFQUERY name="qPeople_Submitted_Current" datasource="TS">
select * from ts.dbo.ts_hdr where
approval_status = 's'
and (jobsupervisor_eid='#get_supervisor(form.eid)#'
or jobsupervisor_eid in (select eid from ts.dbo.assist where
ass_eid='#get_supervisor(form.eid)#'))
and period='#form.period#'
ORDER by jobsupervisor_eid, eid, period;
</CFQUERY>