Return-Path: 
 <cocoon-dev-return-41745-apmail-xml-cocoon-dev-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org
Received: (qmail 52087 invoked by uid 500); 12 May 2003 12:31:11 -0000
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-dev-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-dev-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-dev@xml.apache.org>
Reply-To: cocoon-dev@xml.apache.org
Delivered-To: mailing list cocoon-dev@xml.apache.org
Received: (qmail 52072 invoked from network); 12 May 2003 12:31:10 -0000
Received: from mailserver2.hrz.tu-darmstadt.de (130.83.22.129)
  by daedalus.apache.org with SMTP; 12 May 2003 12:31:10 -0000
Received: from paris (paris.dvs1.informatik.tu-darmstadt.de [130.83.27.43])
	by mailserver2.hrz.tu-darmstadt.de (8.12.9/8.12.8) with ESMTP id
 h4CCU2Lr001245
	for <cocoon-dev@xml.apache.org>; Mon, 12 May 2003 14:30:02 +0200
Received: from bremen.dvs1.informatik.tu-darmstadt.de (bremen [130.83.27.69])
	by paris (Postfix) with ESMTP id 1C318FF1A
	for <cocoon-dev@xml.apache.org>; Mon, 12 May 2003 14:30:02 +0200 (MET DST)
Received: from haul by bremen.dvs1.informatik.tu-darmstadt.de with local (Exim
 3.36 #1 (Debian))
	id 19FCRN-0007Xu-00
	for <cocoon-dev@xml.apache.org>; Mon, 12 May 2003 14:30:01 +0200
Date: Mon, 12 May 2003 14:30:01 +0200
To: cocoon-dev@xml.apache.org
Subject: Re: _esql_connection.connection should be public
Message-ID: <20030512123001.GF1227@bremen.dvs1.informatik.tu-darmstadt.de>
Reply-To: haul@informatik.tu-darmstadt.de
References: <3EBF4C7C.B5BA85B8@wincor-nixdorf.com> <3EBF65FD.10206@dff.st>
 <3EBF6AE6.EBA1CE7F@wincor-nixdorf.com> <3EBF720C.1080607@dff.st>
 <3EBF7AF0.1EF964B9@wincor-nixdorf.com> <3EBF815F.1020107@dff.st>
 <3EBF886E.46B11760@wincor-nixdorf.com> <3EBF8D35.3080805@dff.st>
 <33572.10.0.0.5.1052742410.squirrel@ags01.agsoftware.dnsalias.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <33572.10.0.0.5.1052742410.squirrel@ags01.agsoftware.dnsalias.com>
Organization: Databases and Distributed Systems Group,
 Darmstadt University of Technology
User-Agent: Mutt/1.5.4i
From: Christian Haul <haul@dvs1.informatik.tu-darmstadt.de>
X-MailScanner: Found to be clean
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

On 12.May.2003 -- 06:26 AM, Antonio Gallardo wrote:
> Torsten Curdt dijo:
> >> IMHO a new esql tag would be the best.
> >> If we make it outside esql we have to care about all imports and
> >> try/catch and what else is realted to java.sql.* in the xsp. This is
> >> not necessary when we make it with esql.
> >> If we create a new tag for returning the connection, I propose also to
> >> create a tag for returning a ResultSet and ResultSetMetaData.
> >> Than we have more freedom in manipulating/assigning all kind of DB
> >> related data.
> >
> > not sure if ResultSet and ResultSetMetaData is really necessary but...
> > care enough for a patch? ;-)
> 
> Hi, sorry to go into your discussion, but maybe
> I dont know if this is a valid but something like:
> 
> Syntax:
> <get-field pool="MyPoolName" table="MyTableName" field="MyRequestedfield"
> condition="anotherfield=3" default="ERROR"/>
> 
> internal process:
> 1-Create a conection to "MyPoolName" Database.
> 2-Create a SQL string to retrieve the field from the given table using the
> given condition:
> 
> SELECT MyRequestedfield FROM MyTableName WHERE MyRequestedfield;
> 
> 3-If there is ONE recordset then return the VALUE for the field,
>   else: return default
> 
> 4-Close the connection to the database pool.
> 
> What about something like this? this is just a first draft.
> Is something like that what are you looking for?
> 
> It would be enough to take the company name from a Database.

Maybe that should go into a logicsheet that _uses_ esql?

	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