I'm having a very strange problem with CFMX. I'm creating a very simply
query.

<cfquery name="GetACDReports" datasource="telecom" dbtype="ODBC"
debug>
SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section,
ACDReports.ReportName
FROM ACDReports
ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName
</cfquery>

However, when I add more than one field to the Order By portion of SQL
statement I get a rather nondescript database error:


Error Executing Database Query.  The error occurred in
D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm: line 1
1 : <cfquery name="GetACDReports" datasource="telecom" dbtype="ODBC"
debug>2 : SELECT ACDReports.ReportID, ACDReports.Site,
ACDReports.Section, ACDReports.ReportName3 : FROM ACDReportsSQL   SELECT
ACDReports.ReportID, ACDReports.Site, ACDReports.Section,
ACDReports.ReportName FROM ACDReports ORDER BY
ACDReports.Site,ACDReports.Section,ACDReports.ReportName DATASOURCE
telecomSQLSTATE  &nbsp;
...


Exceptions
08:31:44.044 - Database Exception - in
D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm : line 1
    Error Executing Database Query.Any ideas?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to