Re: jdbc-where-clause

[H�l�ne JOANIN]

[EMAIL PROTECTED] wrote:
> 
> I would like to limit the number of result set to 20 by putting "... AND rownum <= 
>20" but at compilation, it gives me
> 
> jonas-ejb-jar.xml:87:75: Invalid XML: The content of elements must consist of 
>well-formed character data or markup.
> 
> could someone suggest how to fix this? or suggest other alternatives to limit the 
>size of result set
> 
> Thank you very much.
> 

Hi,

Since this is a XML file, the character '<' must be replace by &lt;
So, you have to replace
        "... AND rownum <= 20"
by
        "... AND rownum &lt;= 20"

Kind regards.
H�l�ne.
-- 
-=- H�l�ne JOANIN -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  mailto:[EMAIL PROTECTED]   http://www.evidian.com
  Phone: 33.4.76.29.73.53            Fax: 33.4.76.29.76.00
  Download our EJB Server JOnAS at http://www.objectweb.org
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".