Lucee 5.3.8.201 Error (template) | |
Message | Attribute [name] is not allowed for tag [cfqueryparam] |
Detail | valid attribute names are [value,sqltype,cfsqltype,maxlength,charset,scale,null,list,separator] |
Pattern | <cfqueryparam [value="any"] [sqltype="string"] [cfsqltype="string"] [maxlength="number"] [charset="string"] [scale="number"] [null="boolean"] [list="boolean"] [separator="string"]> |
Documentation | Checks the data type of a query parameter. The cfqueryparam tag is nested within a cfquery tag. It is embedded within the query SQL statement. If you specify its optional parameters, cfqueryparam also performs data validation. Optional: * value (any): Specifies the actual value that Lucee passes to the right of the comparison operator in a where clause. * sqltype (string): The SQL type that the parameter (any type) will be bound to. * cfsqltype (string): This attribute has been deprecated, use instead the attribute "sqltype" that has exact the same functionality. * maxlength (number): Maximum length of the parameter. The default value is the length of the string specified in the value attribute. if the attribute charset is defined, this comparsion will be byte based. * charset (string): This attribute is used for 2 things: - it checks if the given value is compatible with that charset - to check the binary length of the value (see attribute maxlength). * scale (number): Number of decimal places of the parameter. The default value is zero. * null (boolean): Yes or No. Indicates whether the parameter is passed as a null. If Yes, the tag ignores the value attribute. The default is No. * list (boolean): Yes or No. Indicates that the parameter value of the value attribute is a list of values, separated by a separator character. The default is No * separator (string): Specifies the character that separates values in the list of parameter values in the value attribute. The default is a comma. If you specify a list of values for the value attribute, you must also specify the list attribute. |
Stacktrace | The Error Occurred in C:\home\optimalowvision.co.uk\announcement_detail.cfm: line 15 13: select * from tblitems |
Java Stacktrace | lucee.runtime.exp.TemplateException: Attribute [name] is not allowed for tag [cfqueryparam] at lucee.transformer.cfml.tag.CFMLTransformer.createTemplateException(CFMLTransformer.java:1285) at lucee.transformer.cfml.tag.CFMLTransformer.attributeName(CFMLTransformer.java:1180) at lucee.transformer.cfml.tag.CFMLTransformer.attribute(CFMLTransformer.java:1093) at lucee.transformer.cfml.tag.CFMLTransformer.attributes(CFMLTransformer.java:974) at lucee.transformer.cfml.tag.CFMLTransformer.tag(CFMLTransformer.java:688) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:389) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.tag(CFMLTransformer.java:782) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:389) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.tag(CFMLTransformer.java:782) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:389) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.body(CFMLTransformer.java:397) at lucee.transformer.cfml.tag.CFMLTransformer.transform(CFMLTransformer.java:327) at lucee.transformer.cfml.tag.CFMLTransformer.transform(CFMLTransformer.java:319) at lucee.transformer.cfml.tag.CFMLTransformer.transform(CFMLTransformer.java:175) at lucee.runtime.compiler.CFMLCompilerImpl._compile(CFMLCompilerImpl.java:104) at lucee.runtime.compiler.CFMLCompilerImpl.compile(CFMLCompilerImpl.java:76) at lucee.runtime.PageSourceImpl._compile(PageSourceImpl.java:446) at lucee.runtime.PageSourceImpl.compile(PageSourceImpl.java:413) at lucee.runtime.PageSourceImpl.loadPhysical(PageSourceImpl.java:346) at lucee.runtime.PageSourceImpl.loadPageThrowTemplateException(PageSourceImpl.java:237) at lucee.runtime.PageSourceImpl.loadPage(PageSourceImpl.java:1024) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:995) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:65) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2460) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2450) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2421) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1179) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1125) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) |
Timestamp | 29/03/2024 05:49:25 GMT |