Thanks Chris for answer.
Exist a way to know the number of columns to be retrieved for a esql query
(typically a select * from table_name) and how can i pass it to the columns
definition. Or can suggest my a way to make this query on tomcat cocoon
environment..
TIA
Mauro
From: Christian Haul <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: ESQL - select * from any_table
Date: Mon, 6 Aug 2001 09:25:11 +0200
MIME-Version: 1.0
Received: from [64.208.42.41] by hotmail.com (3.2) with ESMTP id
MHotMailBD379185008440042A1D40D02A2909C10; Mon, 06 Aug 2001 00:25:58 -0700
Received: (qmail 59541 invoked by uid 500); 6 Aug 2001 07:25:29 -0000
Received: (qmail 59530 invoked from network); 6 Aug 2001 07:25:29 -0000
>From cocoon-users-return-22376-mvelasco9 Mon, 06 Aug 2001 00:26:37 -0700
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Precedence: bulk
list-help: <mailto:[EMAIL PROTECTED]>
list-unsubscribe: <mailto:[EMAIL PROTECTED]>
list-post: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
User-Agent: Mutt/1.2.5i
In-Reply-To: <[EMAIL PROTECTED]>; from
[EMAIL PROTECTED] on Sun, Aug 05, 2001 at 12:00:43PM -0500
Organization: Databases and Distributed Systems Group, Darmstadt University
of Technology
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N
On 05.Aug.2001 -- 12:00 PM, Mauro Velasco wrote:
> Hi all,
>
> I'm using ESQL with (Tomcat 3.2.1, Cocoon 1.8.2, WinNT 4 sp6), and need
> select all rows from any table, but I noticed before need know the
columns
> the be retrieved, exist a form to make this query. I'm usign Oracle
8.1.6,
> Sql Server 7 and Mysql.
You're right, you need to know your columns in advance -- but you
could refer to them by number as well. This way it's a bit easier to
do it.
The CVS version (2.1) allows for expressions to refer to columns as
well. I will propably check it in for 2.0 as well today.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
