hi!
i'm using cocoon version cocoon-2.1.4 and an oracle database (xsp with esql)
and i encountered a strange behaviour:
<!-- snip -->
<esql:execute-query>
<esql:query>
SELECT
doc_typ doc_typ,
FROM DA
WHERE id = <request:get-parameter name="id"/>
</esql:query>
<esql:results>
<esql:row-results>
<DOCUMENT_ARCHIVE>
<DOC_TYP><esql:get-string column="doc_typ"
/></DOC_TYP>
</DOCUMENT_ARCHIVE>
</esql:row-results>
</esql:results>
<esql:no-results>
<DOCUMENT_ARCHIVE/>
</esql:no-results>
</esql:execute-query>
and i always get this error:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
contrarch_xml: ERROR 1 (org\apache\cocoon\www\archiver\contrarch_xml.java):
... XSPObjectHelper.xspExpr(contentHandler, // start error (lines 6424-6424)
"Syntax error on token ",", ")" expected" EsqlHelper.getAscii(,"doc_typ","")
// end error ); this.contentHandler.endElement( ... Line 6424, column 0:
Syntax error on token ",", ")" expected
the funny thing is .. it works when i use <esql:get-object column="doc_typ"
/> and it works when i use <esql:get-ascii column="doc_typ" />. when i check
with <esql:get-column-type-name column="1" /> it says it's of type VARCHAR2.
so my question is .. VARCHAR2 is not of type string?
kind regards, sascha
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
