Problem executing esql after xsp

[David <da...@nmp.es>]

Hi Coconians

We have tried in Cocoon 1.8 and esql.xsl 1.39 :


<?xml version="1.0"?>

<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet href="myxsl.xsl" type="text/xsl"?>
<?xml-logicsheet href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>

<xsp:page
language="java"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
> 
<page>

<xsp:logic>
String sentencia="SELECT * FROM table";
</xsp:logic>

<esql:connection>
	<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
	<esql:dburl>...</esql:dburl>
	<esql:username>user</esql:username>
	<esql:password></esql:password>

	<esql:execute-query>
	<esql:query><xsp:expr>sentencia</xsp:expr></esql:query>
       
	<esql:results>
 		<column1><esql:get-string column="column1"/> </column1>
 		<column2><esql:get-string column="definition"/></column2>
              </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>

</esql:connection>

</page>


</xsp:page>

Then we obtain that the xsp tags are processed but not the esql tags.
Maybe, we have an old XSP processor ? Or is necesary to change the
cocoon-properties ?

Bye folks.

Re: Problem executing esql after xsp

[Donald Ball <ba...@webslingerZ.com>]

On Fri, 15 Dec 2000, David wrote:

> Then we obtain that the xsp tags are processed but not the esql tags.
> Maybe, we have an old XSP processor ? Or is necesary to change the
> cocoon-properties ?

gotta make sure that the esql namespace prefix is declared in
cocoon.properies and points to the right place. better asked on
cocoon-users than cocoon-dev.

- donald