As someone else mentioned, change
class1 = "<esql:get-string column="CLASS"/>";
to
class1 = <esql:get-string column="CLASS"/>;
Also, you might run into trouble with
...where SELECTION = '<xsp:expr>currentSelection</xsp:expr>'</esql:query>
, as the XSP compiler might put the quotes and the content on separate
lines, which would give you the error you saw. I would recommend you
change this code to:
...where SELECTION =
<esql:parameter type
="string"><xsp:expr>currentSelection</xsp:expr></esql:parameter>
-Christopher
Hi all,
I was wondering if anyone could help me with the following. I am trying
to put the results from a row of results directly into String variables
as show below and Cocoon isn't happy. I get a unclosed character literal
compilation error.
The XSP I am executing is as follows (the problem area is highlighted
with +-----+)
while (class1 = null) {
<esql:connection>
<esql:pool>autorevs_pool</esql:pool>
<esql:execute-query>
<esql:query>select * from profile where SELECTION =
'<xsp:expr>currentSelection</xsp:expr>'</esql:query>
<esql:max-rows>1</esql:max-rows>
<esql:results>
<esql:row-results>
<xsp:logic>
+-----------------------------------------------------------------------
---------------+
class1 = "<esql:get-string column="CLASS"/>";
engine1 = "<esql:get-string column="ENGINE_TYPE"/>";
+-----------------------------------------------------------------------
----------------+
<title><xsp:expr>class1</xsp:expr></title>
<heading><xsp:expr>engine1</xsp:expr></heading>
</xsp:logic>
</esql:row-results>
</esql:results>
<esql:no-results>
<xsp:logic>
if (currentSelection.equals("Strongly Agree")) {
currentSelection = "Agree";
} else if (currentSelection.equals("Agree")) {
currentSelection = "Undecided";
} else if (currentSelection.equals("Undecided")) {
currentSelection = "Disagree";
} else {
currentSelection = null;
class1 = "error";
}
</xsp:logic>
</esql:no-results>
</esql:execute-query>
</esql:connection>
}
Any help greatly appreciated
Thanks
Tom Place
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
