Another error
after migrating to MX
From the following
code I get an error: Invalid object name 'ae_dt1'.
<cfquery name="toplist" datasource="otg"
maxrows="1">
select Distinct(field2) from ae_dt1
where field8='PUBLIC'
order by field2 desc
</cfquery>
select Distinct(field2) from ae_dt1
where field8='PUBLIC'
order by field2 desc
</cfquery>
If I so the
same query in SQL Query analizer it works. Is there some atiquated CF4.0
code I am using that is not valid with CFMX?
Christopher V.
Holdman
Webmaster - City of
Olathe
work: 913.971.6286
cell: 913.238.4681
