We are running several web sites with the identical code. On just ONE site,
when we hit this query, we get this error. select so.professional_id,
sf.address_2, sf.city, sf.state, sf.id, sf.phone, sf.email, so.object_id,
sf.address_1, sf.id as friend_id, sf.name_alias, e.note, e.name,
e.remind_days_before, oc.id as occasion_type, oc.occasion, re.occasion_date,
re.remind_on, re.event_id, re.media, re.sms_id, m.first_name+' '+m.last_name as
pro_name from reminders re left outer join obgyns.dbo.storeOccasions so on
re.occasion_id = so.id left outer join obgyns.dbo.storeFriends sf on sf.id =
so.friend_id left outer join obgyns.dbo.occasions oc on oc.id = so.occasion_id
left outer join obgyns.dbo.event e on e.event_id = re.event_id left outer join
obgyns.dbo.member m on so.professional_id = m.member_id where re.member_id = 1
and re.site_id=32 order by occasion desc Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'obgyns.dbo.storeOccasions'. The table, storeOccasions, in
the db is DEFINATELY there. No question. It's clearly visible in SQL2000
Enterprise Manager. Always was. The only thing a LITTLE unconventional about
this query is that the reference to obgyns.dbo.storeOccasions is in the
code made up of left outer join #datasource#.dbo.storeOccasions so on
re.occasion_id = so.id and the primary tables are in a datasource OTHER than
#datasource# Actual code is: <cfquery name='o' datasource='m8_reminders'>
select so.professional_id, sf.address_2, sf.city, sf.state, sf.id, sf.phone,
sf.email, so.object_id, sf.address_1, sf.id as friend_id, sf.name_alias,
e.note, e.name, e.remind_days_before, oc.id as occasion_type, oc.occasion,
re.occasion_date, re.remind_on, re.event_id, re.media, re.sms_id,
m.first_name+' '+m.last_name as pro_name from reminders re left outer join
#datasource#.dbo.storeOccasions so on re.occasion_id = so.id left outer join
#datasource#.dbo.storeFriends sf on sf.id = so.friend_id left outer join
#datasource#.dbo.occasions oc on oc.id = so.occasion_id left outer join
#datasource#.dbo.event e on e.event_id = re.event_id left outer join
#datasource#.dbo.member m on so.professional_id = m.member_id where
re.member_id = #smn# and re.site_id=#application.site_id# order by #url.sort#
#url.order# </cfquery> There's no problem with the DSN as the site works
perfectly well elsewhere. And other sites work fine using this same query,
except that #datasource# is different. No caching. Weird. Any ideas,
anyone, Robert