cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Philipp Bo?em <phil...@boessem.de>
Subject AW: ESQL, Multiple Queries
Date Wed, 12 Jun 2002 08:44:50 GMT
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:DHohls@csir.co.za]
Gesendet: Mittwoch, 12. Juni 2002 09:54
An: michael.mangeng@ideefix.net; cocoon-users@xml.apache.org
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

>>> michael.mangeng@ideefix.net 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:     <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>


Mime
View raw message