Re: second try -- trying to make sql evaluate instead of just passingthru sql tags

[Sebastien Koechlin <sk...@ivision.fr>]

Steve Conover wrote:

> I tried putting everything in the same document, and I get this error:
>
> Error found handling the request.
> java.lang.Exception: XSP Java Compiler: Compilation failed for
> _uploadform.java

You have a problem with
    xmlns:user="http://www.groundswell.net/2000/XSP/User"


> <?xml version="1.0"?>
>
> <?cocoon-process type="xsp"?>
>
> <xsp:page
>     language="java"
>     xmlns:user="http://www.groundswell.net/2000/XSP/User"
>     xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>       xmlns:sql="http://www.apache.org/1999/SQL"
> >

Can you remove the 'user' namespace, you don't need it anymore.
Also think about swapping xsp and sql as stylesheet are applied
one by one in order.


>         <sql:query>select fname, lname from employee_t where
> empid=<xsp:expr>request.getParameter("userid")</xsp:expr></sql:query>

Make sure you wrote your query on a single line as Java does
not allow multi-line string.

--
Sébastien Koechlin