Title: Message
If you rename the field to aedt1 without the underscore, do you still get the error?
Marco Seabra
-----Original Message-----
From: Chris Holdman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 04:59 PM
Subject: [KCFusion] Error Executing Database Query

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
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

Reply via email to