Return-Path: 
 <cocoon-users-return-33638-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 13776 invoked by uid 500); 16 May 2002 14:45:45 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 13691 invoked from network); 16 May 2002 14:45:44 -0000
Date: Thu, 16 May 2002 16:45:42 +0200
From: Christian Haul <haul@dvs1.informatik.tu-darmstadt.de>
To: cocoon-users@xml.apache.org
Subject: Re: DatabaseSelectAction, get results
Message-ID: <20020516164542.C1780@bremen.dvs1.informatik.tu-darmstadt.de>
Reply-To: haul@dvs1.informatik.tu-darmstadt.de
References: <DA64F4EF44BCD411910F00508B76BE04020B6E62@nbupost.nbu.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <DA64F4EF44BCD411910F00508B76BE04020B6E62@nbupost.nbu.com>
User-Agent: Mutt/1.3.22.1i
Organization: Databases and Distributed Systems Group,
 Darmstadt University of Technology
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

On 15.May.2002 -- 09:05 PM, Hiloliddin Karimov wrote:
> Hi,
> 
> I try use DatabaseSelectAction for selection. I have searched in the
> archive, but I haven't found solution, please help.
> If I want select all, I try:
> <table name="users">
>   <values>
>     <value param="username" dbcol="username" type="string"/>
>     <value param="balance" dbcol="balance" type="double"/>
>     <value param="status" dbcol="status" type="string"/>
>   </values>
> </table>
> then SQL is: SELECT username, balance, status FROM users WHERE
> and error: unexpected end of SQL command.
> why DatabaseSelectAction still use WHERE?

The DatabaseSelectAction is not meant to be a general database
access. You cannot specify arbitrary where clause for example. Just
retrieve a single row from a table. Of course it could be changed to
not use "WHERE" if no keys are present. But how often do you really
want to retrieve _all_ rows from a database table?

> 2. How can I get results? 
> I see in the "Request logicsheet elements" I can get some more results by
> use:
> <xsp-request:get-parameter-values name="username"/> isn't it?
> is there, to read results by row such as: <esql:results>  <esql:row-results>

Results are stored in request attributes (_not_ parameters!). In
addition, results have a prefix
"org.apache.cocoon.acting.AbstractDatabaseAction:"

Maybe it would be worthwhile to look into the esql logicsheet.

	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. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>