Well, I still have not gotten it to work, and frankly I am just guessing as to what the problem is.
You know, it is quite frustrating to spend several days looking through docs and email archives and see this same problem over and over, yet I find no solution. Several email threads to the list have died out with no solution apparent. Frustrating. On Tue, 2007-02-27 at 16:25 +0100, Tobia wrote: > J.D. Williams scrisse: > > <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > > <sql:query> > > select name from user where name = > > '<sql:substitute-value name="${request:param:username}"/>' > > </sql:query> > > </sql:execute-query> > > That looks wrong. > > Try name="request-param:username", with a dash in request-param and > without the ${ } construct. If that doesn't work, you will have to pass > the parameter to the SQL transformer from the sitemap: > > <map:transform type="sql"> > <map:parameter name="username" value="{request-param:username}"/> > </map:transform> > > and then use the plain name: > > <sql:substitute-value name="username"/> > > > Tobia > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
