RE: [KCFusion] Error Executing Database Query

[Bruce Dunwiddie]

Title: Message

 

I can't see anything codewise that would cause that. I would think it'd be something in your setup for the otg datasource. Maybe you have it pointing to the wrong database or server?

Bruce Dunwiddie
Ticket Technology
P: 866.543.3331
F: 913.451.7832
[EMAIL PROTECTED]

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Chris Holdman
Sent: Wednesday, October 15, 2003 3:59 PM
To: '[EMAIL PROTECTED]'
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
</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