cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicky Feldman <nicky7...@yahoo.com>
Subject esql taglib: 2nd query results won't show up
Date Tue, 14 Nov 2000 15:36:33 GMT
Hi,
I have just begun to cocoon and am trying to reproduce
the esql taglib example from the sql samples. I didn't
change ANYTHING in 'samples/esql.xml' except db info
and queries; however, while the first query results
show up as a string, there are no signs of the 2nd
query results. What am I doing wrong? Thanks a lot for
your patience with a novice.
esql.xml code:
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?xml-logicsheet
href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<xsp:page language="java" 
xmlns:esql="http://apache.org/cocoon/SQL/v2"
xmlns:xsp="http://www.apache.org/1999/XSP/Core">
	<page>
		<esql:execute-query>
		
<esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
		
<esql:dburl>jdbc:odbc:orcl.test.star.com</esql:dburl>
			<esql:username>uid</esql:username>
			<esql:password>pwd</esql:password>
			<esql:query>Select id from customer</esql:query>
				<esql:results>
					<customer>
						<esql:get-string column="id"/>
						<esql:execute-query>
							<esql:query>Select circuit_type from circuit
where upper(circuit.customer_id)=
upper('<esql:get-string column="id" ancestor="1"/>')
group by circuit_type </esql:query>
							<esql:results>
								<circuit>
									<esql:get-string column="circuit_type"/>
								</circuit>
							</esql:results>
						</esql:execute-query>
					</customer>
				</esql:results>
			<esql:no-results>
				<error>no results were found</error>
			</esql:no-results>
			<esql:error-results>
				<message>
					<esql:get-message/>
				</message>
				<stacktrace>
					<esql:get-stacktrace/>
				</stacktrace>
			</esql:error-results>
		</esql:execute-query>
	</page>
</xsp:page>

__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.com/

Mime
View raw message