Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 31643 invoked by uid 500); 6 Aug 2001 16:43:50 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 31624 invoked from network); 6 Aug 2001 16:43:50 -0000 X-Originating-IP: [63.117.75.34] From: "Mauro Velasco" To: cocoon-users@xml.apache.org Cc: haul@informatik.tu-darmstadt.de Bcc: Subject: Re: ESQL - select * from any_table Date: Mon, 06 Aug 2001 11:43:25 -0500 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 06 Aug 2001 16:43:25.0664 (UTC) FILETIME=[E9A0C600:01C11E96] X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N 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 Reply-To: haul@informatik.tu-darmstadt.de To: cocoon-users@xml.apache.org 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 cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Delivered-To: mailing list cocoon-users@xml.apache.org Message-ID: <20010806092511.J14964@bremen.dvs1.informatik.tu-darmstadt.de> References: User-Agent: Mutt/1.2.5i In-Reply-To: ; from mvelasco9@hotmail.com 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 haul@informatik.tu-darmstadt.de 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: For additional commands, e-mail: _________________________________________________________________ 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: For additional commands, e-mail: