header

Life Sciences Data Archive

@ Johnson Space Center, Houston, Texas

Advanced Search: DIL

Image Gallery Advance Search

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]ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

The error occurred in E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_middle_form_adv.cfm: line 61
Called from E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_start_adv.cfm: line 30
Called from E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_middle_form_adv.cfm: line 61
Called from E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_start_adv.cfm: line 30

59 : 		 <cfif explore_browser is "Yes"> 
60 : 		 le.experiment_title,
61 : 		 <cfelse>
62 : 		 'experiment_title'=convert(varchar(35), le.experiment_title)+'..',
63 : 		 </cfif>

SQLSTATE	HY000
SQL	SELECT DISTINCT 'experiment_title'=convert(varchar(35), le.experiment_title)+'..', le.experiment_id FROM ls_image i, ls_image_experiment ie, ls_experiment le WHERE i.image_id=ie.image_id AND ie.experiment_id=le.experiment_id ORDER BY le.experiment_title
VENDORERRORCODE	145
DATASOURCE	LocalServer

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address	38.103.63.18
Referrer
Date/Time	09-May-08 08:13 AM

Stack Trace

at cfphoto_search_middle_form_adv2ecfm1324488973.runPage(E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_middle_form_adv.cfm:61) at cfphoto_search_start_adv2ecfm98076609.runPage(E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_start_adv.cfm:30) at cfphoto_search_middle_form_adv2ecfm1324488973.runPage(E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_middle_form_adv.cfm:61) at cfphoto_search_start_adv2ecfm98076609.runPage(E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_start_adv.cfm:30)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1210)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
	at cfphoto_search_middle_form_adv2ecfm1324488973.runPage(E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_middle_form_adv.cfm:61)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:280)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2654)
	at cfphoto_search_start_adv2ecfm98076609.runPage(E:\lsda-web-root\lsda-web\lsda_online\scripts\photoGallery\photo_search_start_adv.cfm:30)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
	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.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)