cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Maxime.Ghey...@swisscom.com>
Subject FW: Add/Remove/Edit Sql entries with buttons (using ESQL)
Date Tue, 10 Dec 2002 13:29:49 GMT
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="add-workflow"
      src="org.apache.cocoon.acting.DatabaseAddAction" />
      <map:action name="del-workflow"
      src="org.apache.cocoon.acting.DatabaseDeleteAction" />
      <map:action name="upd-workflow"
      src="org.apache.cocoon.acting.DatabaseUpdateAction" />

And these action-sets

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

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


Where  <input type="submit" value="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>


Mime
View raw message