Return-Path: 
 <cocoon-dev-return-41741-apmail-xml-cocoon-dev-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org
Received: (qmail 43299 invoked by uid 500); 12 May 2003 12:26:52 -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 43280 invoked from network); 12 May 2003 12:26:51 -0000
Received: from vamana-60.cablenet.com.ni (HELO ags01.agsoftware.dnsalias.com)
 (216.6.48.60)
  by daedalus.apache.org with SMTP; 12 May 2003 12:26:51 -0000
Received: from ags01.agsoftware.dnsalias.com (localhost [127.0.0.1])
	by ags01.agsoftware.dnsalias.com (8.12.8/8.12.5) with ESMTP id h4CCQphJ020447
	for <cocoon-dev@xml.apache.org>; Mon, 12 May 2003 06:26:51 -0600
Received: (from apache@localhost)
	by ags01.agsoftware.dnsalias.com (8.12.8/8.12.8/Submit) id h4CCQot6020445;
	Mon, 12 May 2003 06:26:50 -0600
X-Authentication-Warning: ags01.agsoftware.dnsalias.com: apache set sender to
 agallardo@agsoftware.dnsalias.com using -f
Received: from 10.0.0.5
        (SquirrelMail authenticated user agallardo)
        by ags01.agsoftware.dnsalias.com with HTTP;
        Mon, 12 May 2003 06:26:50 -0600 (CST)
Message-ID: <33572.10.0.0.5.1052742410.squirrel@ags01.agsoftware.dnsalias.com>
Date: Mon, 12 May 2003 06:26:50 -0600 (CST)
Subject: Re: _esql_connection.connection should be public
From: "Antonio Gallardo" <agallardo@agsoftware.dnsalias.com>
To: <cocoon-dev@xml.apache.org>
In-Reply-To: <3EBF8D35.3080805@dff.st>
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>
X-Priority: 3
Importance: Normal
X-Mailer: SquirrelMail (version 1.2.11)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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.

Best Regards,

Antonio Gallardo.