On Monday 03 March 2003 12:53, you wrote:
> On Mon, 3 Mar 2003, David Goodenough wrote:
> > <sql:query>
> > SELECT dno, action, destination, quantity, updated FROM load
> > WHERE <c:out value="${where}" />
> > </sql:query>
> >
> > When I try to run this I get an SQL exception
> > (javax.servlet.ServletException) :-
> >
> > SELECT dno, action, due, destination, quantity, updated FROM load
> > WHERE area = 'NW'
> > ORDER BY due DESC FOR READ ONLY
> >
> > : ERROR: parser: parse error at or near "NW"
>
> The <c:out> tag by default escapes quotation marks, as they are XML
> metacharacters. Use the escapeXml="false" attribute to get around your
> problem. (The problem would show up more clearly if you looked at the raw
> HTML source of the page that's giving you this error message.)
Thank you, I knew it had to be something simple that I was doing wrong.
That fixed the problem.
Now for the next one. I am trying to use the SQL resultset method
isLimitedByMaxRows. I tried <c:if test="${result.isLimitedByMaxRows}">
but that got reject with unable to get value of ... with operator ".",
so I tried result.limitedByMaxRows and that got the same. Presumably it
is looking for a get method, how do I access an is method?
David
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
