kills it?
-d
----- Original Message -----
From: "Eric Davis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 11:14 AM
Subject: CFMX 6.1 and Order By Error
> 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
> ...
>
> 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]
