Hey, I didn't know you could pass parameters like that in cfquery! Nice..Is this a Railo specific addition? I mean the params attribute? Couldn't find this in the docs.
--To view this discussion on the web visit https://groups.google.com/d/msgid/railo/9e8126e7-0777-411a-bfd7-f13c696ef780%40googlegroups.com.
Did you find this reply useful? Help the Railo community and add it to the Railo Server wiki at https://github.com/getrailo/railo/wiki
---
You received this message because you are subscribed to the Google Groups "Railo" group.
Message | variable [____RTN] doesn't exist |
Stacktrace | The Error Occurred inx /queryExecute.cfm: line 36 called from /_query.cfm: line 18 |
Java Stacktrace | variable [____RTN] doesn't exist
at railo.runtime.type.scope.UndefinedImpl.get(UndefinedImpl.java:208):208 at queryexecute_cfm$cf.udfCall(/queryExecute.cfm:36):36 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:92):92 at railo.runtime.type.UDFImpl._call(UDFImpl.java:306):306 at railo.runtime.type.UDFImpl.call(UDFImpl.java:207):207 at railo.runtime.functions.system.CFFunction.call(CFFunction.java:81):81 at _query_cfm$cf.call(/_query.cfm:18):18 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:912):912 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:864):864 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:206):206 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2217):2217 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2184):2184 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:332):332 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 at javax.servlet.http.HttpServlet.service(HttpServlet.java:848):848 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669):669 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:457):457 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137):137 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557):557 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231):231 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075):1075 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384):384 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193):193 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009):1009 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135):135 at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:224):224 at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154):154 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116 at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:317):317 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116 at org.eclipse.jetty.server.Server.handle(Server.java:368):368 at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:488):488 at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:932):932 at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:994):994 at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:640):640 at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235):235 at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82):82 at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628):628 at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52):52 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608):608 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543):543 at java.lang.Thread.run(Unknown Source):-1 |
query name="local.____rtn" attributeCollection="#local.____attributeCollection#" {
echo(local.____sqlString);
}
return ____rtn;
--
Did you find this reply useful? Help the Railo community and add it to the Railo Server wiki at https://github.com/getrailo/railo/wiki
---
You received this message because you are subscribed to the Google Groups "Railo" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/railo/0c499156-73db-4eb2-9094-be54673eb743%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
-- Igal Sapir Railo Core Developer http://getRailo.org/
--
Did you find this reply useful? Help the Railo community and add it to the Railo Server wiki at https://github.com/getrailo/railo/wiki
---
You received this message because you are subscribed to the Google Groups "Railo" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/railo/2955cdea-07f7-457c-86e0-eb8a0d01329e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Does that SQL run within mySQL directly?
That is, in something like mySQL workbench?
--
Did you find this reply useful? Help the Railo community and add it to the Railo Server wiki at https://github.com/getrailo/railo/wiki
---
You received this message because you are subscribed to the Google Groups "Railo" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/railo/db1faab3-151a-47e3-81f4-cf29d6867495%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/railo/d602cb88-e760-4d9d-977c-8f75a93fe05c%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/railo/84e1bf6e-b7ef-4f39-8b9f-f523650f8df1%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/railo/CAPURtC02Vzshx1DLrwGMgtAZRmMG%3DqB14iHfNTKcjNe_sbx6Og%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
-- Igal Sapir Railo Core Developer http://getRailo.org/
the working version is 5.1.23
To view this discussion on the web visit https://groups.google.com/d/msgid/railo/536AFF78.9040003%40getrailo.org.