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/RILEY/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
DATASOURCE   RILEY
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.211.100.183
Referrer  
Date/Time   27-Nov-14 03:24 PM
Stack Trace
at cfQRY2d12ecfm1393001413.runPage(D:/WebInetpub/NGA/Exhibition/Application/Includes/QRY-1.cfm:93) at cfDefault2ecfm221261820.runPage(D:/WebInetpub/NGA/Exhibition/RILEY/Default.cfm:7) at cfQRY2d12ecfm1393001413.runPage(D:/WebInetpub/NGA/Exhibition/Application/Includes/QRY-1.cfm:93) at cfDefault2ecfm221261820.runPage(D:/WebInetpub/NGA/Exhibition/RILEY/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 cfDefault2ecfm221261820.runPage(D:\WebInetpub\NGA\Exhibition\RILEY\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)