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