ESQL - select * from any_table

[Mauro Velasco]

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.

Any help is great...

Thanks in advanced

Mauro


_
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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Re: ESQL - select * from any_table

[Christian Haul]

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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Re: ESQL - select * from any_table

[Mauro Velasco]

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 -
Received: (qmail 59530 invoked from network); 6 Aug 2001 07:25:29 -
>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]>

Re: ESQL - select * from any_table

[Mauro Velasco]

Thanx again Chris, I'll try this now..



From: Christian Haul <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Mauro Velasco <[EMAIL PROTECTED]>
Subject: Re: ESQL - select * from any_table
Date: Mon, 6 Aug 2001 19:26:50 +0200
MIME-Version: 1.0
Received: from [130.83.126.41] by hotmail.com (3.2) with ESMTP id 
MHotMailBD381E5C00A8400438E682537E2990450; Mon, 06 Aug 2001 10:26:53 -0700
Received: from london (london.dvs1.informatik.tu-darmstadt.de 
[130.83.27.27])by mailserver1.hrz.tu-darmstadt.de (8.9.1a/8.9.1) with ESMTP 
id TAA20372for <[EMAIL PROTECTED]>; Mon, 6 Aug 2001 19:25:47 +0200 (MET 
DST)
Received: by london (Postfix, from userid 11012)id 21B0316487; Mon,  6 Aug 
2001 19:26:51 +0200 (MET DST)
>From [EMAIL PROTECTED] Mon, 06 Aug 2001 10:28:34 -0700
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
User-Agent: Mutt/1.2i
In-Reply-To: <[EMAIL PROTECTED]>; from 
[EMAIL PROTECTED] on Mon, Aug 06, 2001 at 11:43:25AM -0500
Organization: Databases and Distributed Systems Group, Darmstadt University 
of Technology

On 06.Aug.2001 -- 11:43 AM, Mauro Velasco wrote:
 > 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..

Yes,  does it. Thus

  
 

  for (int i=0; i < ; i++) {
 i
   }


  

would output all columns in a table. But for this you could also do

  
 
   

  

which would produce a similar result (not the same, as ex.2 does not
use  tags but column names... so the result would need to be
transformed properly)

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


_
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]>