You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Pål Wester <pa...@never.no> on 2001/01/26 21:11:57 UTC

possible bug in esql taglib?

I don't know why, but when I do this:
	<esql:connection>
		<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
		<esql:dburl>jdbc:mysql://localhost:3306/quart</esql:dburl>
		<esql:username>user</esql:username>
		<esql:password>pass</esql:password>
		<esql:execute-query>
			<esql:query><xsp:expr>insertquery</xsp:expr></esql:query>
			<esql:error-results>
				<section>
					Error: <esql:get-message/>
				<section>
			</esql:error-results>
		</esql:execute-query>
	</esql:connection>
and my query is noing an insert that results in a "double pri key error"
i dont get any errormessages and the whole <esql:error-results> is ignored.
But if I write:
<section>
	<esql:connection>
		<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
		<esql:dburl>jdbc:mysql://localhost:3306/quart</esql:dburl>
		<esql:username>user</esql:username>
		<esql:password>pass</esql:password>
		<esql:execute-query>
			<esql:query><xsp:expr>insertquery</xsp:expr></esql:query>
			<esql:error-results>
				Error: <esql:get-message/>
			</esql:error-results>
		</esql:execute-query>
	</esql:connection>
</section>

I will get the errormessage, but if it went ok, it will result in
<section>
</section>
as a result. i would like to avoid that.

What am I doing wrong, do I have a wrong version of esql??

mvh:
Pål Wester

Re: possible bug in esql taglib?

Posted by Donald Ball <ba...@webslingerZ.com>.
On Fri, 26 Jan 2001, [iso-8859-1] P�l Wester wrote:

> I don't know why, but when I do this:
> 	<esql:connection>
> 		<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
> 		<esql:dburl>jdbc:mysql://localhost:3306/quart</esql:dburl>
> 		<esql:username>user</esql:username>
> 		<esql:password>pass</esql:password>
> 		<esql:execute-query>
> 			<esql:query><xsp:expr>insertquery</xsp:expr></esql:query>
> 			<esql:error-results>
> 				<section>
> 					Error: <esql:get-message/>
> 				<section>
> 			</esql:error-results>
> 		</esql:execute-query>
> 	</esql:connection>
> and my query is noing an insert that results in a "double pri key error"
> i dont get any errormessages and the whole <esql:error-results> is ignored.

looks like a bug to me. you should get:

<section>Error: blah blah</section>

i'll poke around and see what's up.

- donald