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

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.

 
The error occurred in M:/WebSites/NMNH-Botany/Antilles/WestIndies/getonerecord_emu.cfm: line 40
38 : FROM ((((GRETANT LEFT JOIN LesserAnt1 ON (GRETANT.genus = LesserAnt1.genus) AND (GRETANT.epithet = LesserAnt1.epithet) AND (isnull(GRETANT.l_rank,'') = isnull(LesserAnt1.l_rank,'')) AND  (isnull(GRETANT.l_epithet,'') = isnull(LesserAnt1.l_epithet,''))) LEFT JOIN VirginIslands ON GRETANT.ID = VirginIslands.AcceptedID) LEFT JOIN Hispaniola ON GRETANT.ID = Hispaniola.AcceptedID) LEFT JOIN PuertoRico ON GRETANT.ID = PuertoRico.accepted) LEFT JOIN commonNames ON GRETANT.ID = commonNames.AcceptedID
39 : where 
40 : gretant.id = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#ID#">
41 : order by gretant.family, gretant.genus, gretant.epithet, gretant.l_epithet;
42 : </cfquery>

Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.224.150.24
Referrer  
Date/Time   17-Oct-18 02:03 AM
Stack Trace
at cfgetonerecord_emu2ecfm2103723837._factor7(M:/WebSites/NMNH-Botany/Antilles/WestIndies/getonerecord_emu.cfm:40) at cfgetonerecord_emu2ecfm2103723837.runPage(M:/WebSites/NMNH-Botany/Antilles/WestIndies/getonerecord_emu.cfm:1)

coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:118)
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:70)
	at coldfusion.sql.Parameter.getMappingValues(Parameter.java:63)
	at coldfusion.sql.InParameter.setStatement(InParameter.java:72)
	at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1500)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfgetonerecord_emu2ecfm2103723837._factor7(M:\WebSites\NMNH-Botany\Antilles\WestIndies\getonerecord_emu.cfm:40)
	at cfgetonerecord_emu2ecfm2103723837.runPage(M:\WebSites\NMNH-Botany\Antilles\WestIndies\getonerecord_emu.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:207)
	at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)