Turtle Warehouse Title Image
Blank space image
Updated 15:37 CST on 20 Feb 2013
Black Dot Image Home
Black Dot Image Disclaimer
Black Dot Image Introduction
Black Dot Image Divisions
Black Dot Image Districts
Black Dot Image Projects
Black Dot Image Turtle Species
Black Dot Image Region
Black Dot Image Total Cubic Yards
Black Dot Image Fiscal Year Table
Black Dot Image Fiscal Year Graph
Black Dot Image Annual Allotted Takes
Black Dot Image Annual Relocated Turtles
Black Dot Image Total Turtle Takes
Black Dot Image Takes Graphs
Black Dot Image Fiscal Year
Black Dot Image Calendar Year
Black Dot Image Fiscal Year
Black Dot Image Takes
Black Dot Image Water Temp
Black Dot Image References
Black Dot Image Reports
Black Dot Image Biological Assessments/ Opinions
Black Dot Image Sea TurtleInspection Checklist for Hopper Dredges
Black Dot Image Regulatory Hopper Dredge Inspection Checklist
Black Dot Image Stranding Data
Black Dot Image Observer Criteria
Black Dot Image Observer Forms
Black Dot Image Trawling Form
Black Dot Image Tagging Form
Black Dot Image District Checklist
Black Dot Image Sea Turtle Deflector Draghead-Design Specifications
Black Dot Image Corps/Industry Hopper Dredge Schedule
Black Dot Image Florida Shore Protection & Sea Turtle Management System
 Blank image space

Total Takes for Calendar Year 2012

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][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression 'CalendarYear LIKE '?'.
 
The error occurred in D:/webdocs/el/seaturtles/takes.cfm: line 2150
Called from D:/webdocs/el/seaturtles/takes.cfm: line 2145
Called from D:/webdocs/el/seaturtles/takes.cfm: line 1
Called from D:/webdocs/el/seaturtles/takes.cfm: line 2150
Called from D:/webdocs/el/seaturtles/takes.cfm: line 2145
Called from D:/webdocs/el/seaturtles/takes.cfm: line 1
 
2148 : SELECT TurtleTake_d, Species, FiscalYear, CalendarYear, ProjectId
2149 : FROM TurtleData
2150 : WHERE CalendarYear LIKE '<cfqueryparam value="#URL.Year#" cfsqltype="CF_SQL_Integer">
2151 : </cfquery>
2152 :
VENDORERRORCODE   -3100
SQLSTATE   42000
SQL    SELECT TurtleTake_d, Species, FiscalYear, CalendarYear, ProjectId FROM TurtleData WHERE CalendarYear LIKE ' (param 1)
DATASOURCE   takehouse
Resources:

Browser   CCBot/2.0
Remote Address   50.16.166.175
Referrer  
Date/Time   18-Jun-13 07:01 PM
Stack Trace
at cftakes2ecfm1587123800._factor113(D:/webdocs/el/seaturtles/takes.cfm:2150) at cftakes2ecfm1587123800._factor177(D:/webdocs/el/seaturtles/takes.cfm:2145) at cftakes2ecfm1587123800.runPage(D:/webdocs/el/seaturtles/takes.cfm:1) at cftakes2ecfm1587123800._factor113(D:/webdocs/el/seaturtles/takes.cfm:2150) at cftakes2ecfm1587123800._factor177(D:/webdocs/el/seaturtles/takes.cfm:2145) at cftakes2ecfm1587123800.runPage(D:/webdocs/el/seaturtles/takes.cfm:1) 

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression 'CalendarYear LIKE '?'.
	at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
	at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
	at macromedia.sequelink.ssp.Chain.send(Unknown Source)
	at macromedia.sequelink.ctxt.stmt.StatementContext.associate(Unknown Source)
	at macromedia.jdbc.sequelink.SequeLinkImplStatement.prepare(Unknown Source)
	at macromedia.jdbc.slbase.BaseImplStatement.prepare(Unknown Source)
	at macromedia.jdbc.slbase.BasePreparedStatement.prepareSQL(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.preProcessSQL(Unknown Source)
	at macromedia.jdbc.slbase.BasePreparedStatement.<init>(Unknown Source)
	at macromedia.jdbc.slbase.BaseConnection.prepareStatement(Unknown Source)
	at macromedia.jdbc.slbase.BaseConnection.prepareStatement(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunConnection.prepareStatement(JRunConnection.java:353)
	at coldfusion.server.j2ee.sql.JRunConnectionHandle.prepareStatement(JRunConnectionHandle.java:74)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1340)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:854)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:586)
	at cftakes2ecfm1587123800._factor113(D:\webdocs\el\seaturtles\takes.cfm:2150)
	at cftakes2ecfm1587123800._factor177(D:\webdocs\el\seaturtles\takes.cfm:2145)
	at cftakes2ecfm1587123800.runPage(D:\webdocs\el\seaturtles\takes.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	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:201)
	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:286)
	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)