cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sascha Guscheh" <sascha.gusc...@irm.at>
Subject esql:get-string bug?
Date Tue, 12 Aug 2008 09:33:39 GMT
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message