Return-Path: 
 <users-return-66089-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 81673 invoked from network); 17 Apr 2004 18:06:28 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 17 Apr 2004 18:06:28 -0000
Received: (qmail 45255 invoked by uid 500); 17 Apr 2004 18:06:12 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 44973 invoked by uid 500); 17 Apr 2004 18:06:10 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
list-post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 44955 invoked from network); 17 Apr 2004 18:06:10 -0000
Received: from unknown (HELO host02.fachschaft.informatik.tu-darmstadt.de)
 (130.83.162.42)
  by daedalus.apache.org with SMTP; 17 Apr 2004 18:06:10 -0000
Received: by host02.fachschaft.informatik.tu-darmstadt.de (Postfix,
 from userid 1024)
	id C71846423D; Sat, 17 Apr 2004 20:06:15 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1])
	by host02.fachschaft.informatik.tu-darmstadt.de (Postfix) with ESMTP id
 C6113CEDD6
	for <users@cocoon.apache.org>; Sat, 17 Apr 2004 20:06:15 +0200 (CEST)
Date: Sat, 17 Apr 2004 20:06:15 +0200 (CEST)
From: Frank Thilo Mueller <thilom@fachschaft.informatik.tu-darmstadt.de>
To: users@cocoon.apache.org
Subject: Re: Generic Table printout for Oracle ORDBMS
In-Reply-To: <407FB7CD.2070004@web.de>
Message-ID: 
 <Pine.LNX.4.58.0404171958180.5363@host02.fachschaft.informatik.tu-darmstadt.de>
References: 
 <Pine.LNX.4.58.0404151735220.4284@host02.fachschaft.informatik.tu-darmstadt.de>
 <407FB7CD.2070004@web.de>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Dear Christian,

thank you very much for your answer. I already had tried both ways
before but I couldnt reach the result I am heading at.

Im using the esql example to print out table column name number i.

> <esql:get-column-name>
>    <esql:param name="column"><xsp:expr>i</xsp:expr></esql:param>
> </esql:get-column-name>

If I replace this i with a 1, everything is fine. If I define int 1=1
outside of the <content> then it gives me an error:

org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
esql_xsp: ERROR 1
(org\apache\cocoon\www\samples\databases\xsp\esql_xsp.java): ... default:
this.characters("\n "); // start error (lines 588-588) "String literal is
not properly closed by a double-quote"
XSPObjectHelper.xspExpr(contentHandler,
_esql_query.getResultSet().getMetaData().getColumnName(" // end error i
")); this.characters("\n\n\t"); ... Line 588, column 0: String literal is
not properly closed by a double-quote

Which says nearly nothing to me.

Any ideas ?

Thank you,

Thilo

---------
more detailed code sample

  <page>
   <title>A Database Driven XSP Page</title>
    <resources>
       <resource type="file"
href="../transform/sql-page.xml.sql">Schema</resource>
       <resource type="doc" href="userdocs/xsp/esql">ESQL</resource>
    </resources>

<xsp:logic>
int i=1;
</xsp:logic>


   <content>

   <esql:connection>
     <esql:pool>personnel</esql:pool>

<para>

Die Zahl i hat den Wert <xsp:expr>i</xsp:expr>

</para>
<para>
  Generische Tabellenausgabe
</para>


       <para>
           Spaltenname
       </para>

       <esql:execute-query>
         <esql:query>select * from employee</esql:query>
         <esql:results>
            <esql:get-column-name>
		<esql:param name="column">
		<xsp:expr>i</xsp:expr>
		</esql:param>
	    </esql:get-column-name>

	</esql:results>
       </esql:execute-query>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org