Return-Path: 
 <cocoon-users-return-43653-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 34624 invoked by uid 500); 10 Dec 2002 15:11:39 -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 34611 invoked from network); 10 Dec 2002 15:11:38 -0000
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Add/Remove/Edit Sql entries with buttons (using ESQL)
Date: Tue, 10 Dec 2002 16:11:19 +0100
Message-ID: <DD00ACEE56F4A04DB7092539C493FADC4D8788@sxmbx06.corproot.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Add/Remove/Edit Sql entries with buttons (using ESQL)
Thread-Index: AcKgXbVqNFoBdEjvQiWDrg6QmX2nWQAAGZ9g
From: <Maxime.Gheysen@swisscom.com>
To: <cocoon-users@xml.apache.org>
X-OriginalArrivalTime: 10 Dec 2002 15:11:19.0414 (UTC)
                       FILETIME=[648D3160:01C2A05E]
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

If I write <input type=3D"submit" value=3D"Save" =
name=3D"cocoon-action-Add"/>
I just come back to the previous page. I think it's because I haven't
write the ID. That means :=20

The database contains following collumns : ID - Name - Dispatcher
The xsp page contains : text field for name - Select object for
dipatcher

I used a form.

-----Original Message-----
From: Geoff Howard [mailto:cocoon@leverageweb.com]=20
Sent: Tuesday, December 10, 2002 4:13 PM
To: cocoon-users@xml.apache.org
Subject: RE: Add/Remove/Edit Sql entries with buttons (using ESQL)


You need a proper name attribute on your submit button to get it to call
the action.

For instance, in your case (if you are not using an older version of
cocoon):
 <input type=3D"submit" value=3D"Save" name=3D"cocoon-action-Add"/> =
would call
the "Add" action from your workflow action-set.  Similarly,
cocoon-action-Delete and cocoon-action-Update would call the others.

The value attribute is only there for display (this was not true at some
point in the past) and the name attribute is not visible to the end
user. As such, you probably want to name your actions more restrictively
as you may have many Add, Delete, and Update.  something like
action=3D"add-workflow" corresponding to "cocoon-action-add-workflow"
might keep things easier to follow and potentially prevent problems.

The magic string "cocoon-action-" is not easily modified (I believe it's
compiled in).

Geoff

-----Original Message-----
From: Maxime.Gheysen@swisscom.com [mailto:Maxime.Gheysen@swisscom.com]
Sent: Tuesday, December 10, 2002 8:30 AM
To: cocoon-users@xml.apache.org
Subject: FW: Add/Remove/Edit Sql entries with buttons (using ESQL)


Excuse me, previous message was not complete :



Hello,
I want to Add/Remove/Edit Sql entries by clicking on buttons. I tryied
with these 3 actions :

    <map:actions>
      <map:action name=3D"add-workflow"
      src=3D"org.apache.cocoon.acting.DatabaseAddAction" />
      <map:action name=3D"del-workflow"
      src=3D"org.apache.cocoon.acting.DatabaseDeleteAction" />
      <map:action name=3D"upd-workflow"
      src=3D"org.apache.cocoon.acting.DatabaseUpdateAction" />

And these action-sets

  <map:action-sets>
    <map:action-set name=3D"workflow">
      <map:act type=3D"add-workflow" action=3D"Add" />
      <map:act type=3D"del-workflow" action=3D"Delete" />
      <map:act type=3D"upd-workflow" action=3D"Update" />
    </map:action-set>
  </map:action-sets>

. These actions are in my sitemap. Now, if I want them on a button, like
:
<form action=3D"process-workflow" method=3D"POST">
 <input name=3D"process" type=3D"hidden" value=3D"Upd"/>
 <select name=3D"SELdispatcher">
	  <esql:connection>
	    	<esql:pool>personnel</esql:pool>
		<esql:execute-query>
		 <esql:query>select usrID, usrName from wfUsers order by
usrName</esql:query>
		 <esql:results>
		  <esql:row-results>
		  <option>
			  <xsp:attribute name=3D"value"><esql:get-int
column=3D"usrID"/></xsp:attribute>
	              <esql:get-string column=3D"usrName"/>
		  </option>
		  </esql:row-results>
		 </esql:results>
		 </esql:execute-query>
	  </esql:connection>
 </select>
 <input name=3D"wfName" type=3D"text"/>
 <input type=3D"submit" value=3D"Save"/>
</form>


Where  <input type=3D"submit" value=3D"Save"/> is the button to update =
sql
database.


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

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




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

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


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

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