i have got following runnig. is probably not the most elegant way, but it works.
<?xml version="1.0"?> <xsp:page xmlns:xsp="http://apache.org/xsp"; xmlns:xsp-formval="http://apache.org/xsp/form-validator/2.0"; xmlns:xsp-request="http://apache.org/xsp/request/2.0"; xmlns:esql="http://apache.org/cocoon/SQL/v2";> <document> <esql:connection> <esql:pool>seminarnoten</esql:pool> <esql:execute-query> <esql:query> update studenten set matrikelnr='<xsp-request:get-parameter name="matrikelnr"/>' where id = '<xsp-request:get-parameter name="id"/>' </esql:query> </esql:execute-query> <esql:execute-query> <esql:query> update studenten set name='<xsp-request:get-parameter name="name"/>' where id = '<xsp-request:get-parameter name="id"/>' </esql:query> </esql:execute-query> <esql:execute-query> <esql:query> update studenten set vorname='<xsp-request:get-parameter name="vorname"/>' where id = '<xsp-request:get-parameter name="id"/>' </esql:query> </esql:execute-query> <esql:execute-query> <esql:query> update studenten set thema='<xsp-request:get-parameter name="thema"/>' where id = '<xsp-request:get-parameter name="id"/>' </esql:query> </esql:execute-query> <esql:execute-query> <esql:query> update studenten set betreuer='<xsp-request:get-parameter name="betreuer"/>' where id = '<xsp-request:get-parameter name="id"/>' </esql:query> </esql:execute-query> <esql:execute-query> <esql:query> update studenten set abgabetermin='<xsp-request:get-parameter name="abgabetermin"/>' where id = '<xsp-request:get-parameter name="id"/>' </esql:query> </esql:execute-query> <esql:execute-query> <esql:query> update studenten set seminarnote='<xsp-request:get-parameter name="seminarnote"/>' where id = '<xsp-request:get-parameter name="id"/>' </esql:query> </esql:execute-query> <esql:execute-query> <esql:query> select * from studenten </esql:query> <esql:results> <esql:row-results> <text> <esql:get-string column="matrikelnr"/> <esql:get-string column="name"/> <esql:get-string column="vorname"/> <esql:get-string column="thema"/> <esql:get-string column="betreuer"/> <esql:get-string column="abgabetermin"/> <esql:get-string column="seminarnote"/> </text> </esql:row-results> </esql:results> </esql:execute-query> </esql:connection> </document> </xsp:page> -----Ursprungliche Nachricht----- Von: Derek Hohls [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 12. Juni 2002 09:54 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: ESQL, Multiple Queries Mike Suggest you work through the IBM Developer Works Tutorial - Cocoon 2: Build database-driven sites (05/30/2002) it explains things nesting/grouping really clearly... http://www-105.ibm.com/developerworks/education.nsf/dw/xml-onlinecourse-byne west?OpenDocument&Count=500 Derek >>> [EMAIL PROTECTED] 12/06/2002 09:53:30 >>> Hi I m wondering how i can do multiple selects with the esql logicsheet. thanx mike --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
