Error Occurred While Processing Request
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]A column has been specified more than once in the order by list. Columns in the order by list must be unique.

ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsystem.

VENDORERRORCODE

169

SQLSTATE

HY000

SQL

SELECT *, '<img src="http://nga.gov.au/Exhibition/CONSTABLE/IMAGES/400/'+cast(irn AS varchar)+'.jpg" />' AS IMG, '<B>'+namfull+ '</B><BR><I>'+Title+'</I> '+wrkdate+'<br>'+ tech AS CAPTION
FROM ArtistWorksFlat
WHERE 0=0
ORDER BY TITLE, Title

at cfQRY2d12ecfm1393001413.runPage(D:/WebInetpub/NGA/Exhibition/Application/Includes/QRY-1.cfm:93) at cfDefault2ecfm1750431784.runPage(D:/WebInetpub/NGA/Exhibition/CONSTABLE/Default.cfm:7)
at cfQRY2d12ecfm1393001413.runPage(D:/WebInetpub/NGA/Exhibition/Application/Includes/QRY-1.cfm:93) at cfDefault2ecfm1750431784.runPage(D:/WebInetpub/NGA/Exhibition/CONSTABLE/Default.cfm:7)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]A column has been specified more than once in the order by list. Columns in the order by list must be unique.
at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.ddj.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1442)
at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1056)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:685)
at cfQRY2d12ecfm1393001413.runPage(D:\WebInetpub\NGA\Exhibition\Application\Includes\QRY-1.cfm:93)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
at cfDefault2ecfm1750431784.runPage(D:\WebInetpub\NGA\Exhibition\CONSTABLE\Default.cfm:7)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:443)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)