query
RESULTSET
query
  DELETEFLAG DIRECTORY FILENAME OKAYFLAG ORIGCLIENTFILE ORIGCLIENTFILEEXTN RESOURCEID RFTDELETEFLAG
CACHED false
EXECUTIONTIME 15
SQL SELECT dbo.ResourceFileTable.ResourceID as ResourceID, dbo.ResourceFileTable.FileNameOriginal as FileName, dbo.ResourceFileTable.ORIGClientFile, dbo.ResourceFileTable.ORIGClientFileEXTN, dbo.resourceTable.okayFlag, dbo.resourceTable.DeleteFlag AS DeleteFlag, dbo.ResourceFileTable.ORIGFileServerDirectory as directory, dbo.ResourceFileTable.deleteFlag AS RFTDeleteFlag FROM dbo.ResourceFileTable INNER JOIN dbo.resourceTable ON dbo.ResourceFileTable.ResourceID = dbo.resourceTable.resourceID WHERE dbo.resourceTable.DeleteFlag = 0 AND dbo.resourcetable.Okayflag = 'Yes' AND dbo.ResourceFileTable.deleteFlag = 0 AND resourceFileTable.ResourceID='6BGQM071917012818'
Error at: http://appsrv.pace.edu/VOSCOE/index.cfm?do=DownloadFile&res=6BGQM071917012818
Time: 6/24/18 9:57 PM
The 2 parameter of the Left function, which is now -1, must be a positive integer
struct
Detail [empty string]
ErrNumber 0
Message The 2 parameter of the Left function, which is now -1, must be a positive integer
StackTrace coldfusion.runtime.InvalidFunctionArgException: The 2 parameter of the Left function, which is now -1, must be a positive integer at coldfusion.runtime.StringFunc.Left(StringFunc.java:845) at coldfusion.runtime.CFPage.Left(CFPage.java:3244) at cfsanitizefilename2ecfm1220543260$funcSANITIZEFILENAME.runFunction(E:\webroot\VOSCOE\includes\sanitizefilename.cfm:14) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2854) at cffileDownload2ecfm1409703969.runPage(E:\webroot\VOSCOE\ProgramFiles\ViewResource\fileDownload.cfm:25) 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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000) at cfindex2ecfm191736815.runPage(E:\webroot\VOSCOE\index.cfm:87) 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:474) 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.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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57) 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:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) 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(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CF_CFPAGE
LINE 14
RAW_TRACE at cfsanitizefilename2ecfm1220543260$funcSANITIZEFILENAME.runFunction(E:\webroot\VOSCOE\includes\sanitizefilename.cfm:14)
TEMPLATE E:\webroot\VOSCOE\includes\sanitizefilename.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 25
RAW_TRACE at cffileDownload2ecfm1409703969.runPage(E:\webroot\VOSCOE\ProgramFiles\ViewResource\fileDownload.cfm:25)
TEMPLATE E:\webroot\VOSCOE\ProgramFiles\ViewResource\fileDownload.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 87
RAW_TRACE at cfindex2ecfm191736815.runPage(E:\webroot\VOSCOE\index.cfm:87)
TEMPLATE E:\webroot\VOSCOE\index.cfm
TYPE CFML
Type Expression
exprtype positive integer
func Left
param 2
val -1
[empty string]