Return-Path: <balld@webslingerZ.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 15636 invoked from network); 24 Jan 2001 21:37:00 -0000
Received: from rdu25-5-046.nc.rr.com (HELO akira.webslingerZ.com) (24.25.5.46)
  by h31.sny.collab.net with SMTP; 24 Jan 2001 21:37:00 -0000
Received: by akira.webslingerZ.com (Postfix, from userid 501)
	id 8D390130A3; Wed, 24 Jan 2001 16:38:11 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
	by akira.webslingerZ.com (Postfix) with ESMTP id 66AF260B2
	for <cocoon-users@xml.apache.org>; Wed, 24 Jan 2001 16:38:11 -0500 (EST)
Date: Wed, 24 Jan 2001 16:38:10 -0500 (EST)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: <balld@localhost.localdomain>
To: <cocoon-users@xml.apache.org>
Subject: Re: Has esql taglib a template for no-errors??
In-Reply-To: <DDEGJMIMNANCDANDFAAEEEBOCGAA.pal.wester@never.no>
Message-ID: <Pine.LNX.4.30.0101241637370.1198-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=X-UNKNOWN
Content-Transfer-Encoding: QUOTED-PRINTABLE
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

On Wed, 24 Jan 2001, [iso-8859-1] P=E5l Wester wrote:

> I want to do an insert into a table
> and has written following:
>
> <esql:connection>
> =09<esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
> =09<esql:dburl>jdbc:mysql://localhost:3306/quart</esql:dburl>
> =09<esql:username>quartuser</esql:username>
>   =09<esql:password>passwd</esql:password>
>   =09<esql:execute-query>
>     =09=09<esql:query>INSERT INTO Q_ANSATT ( brukid, navn, tel, funksjon,
> passord, avd ) VALUES(
> '<xsp:expr>login</xsp:expr>','<xsp:expr>name</xsp:expr>','<xsp:expr>tel</=
xsp
> :expr>','<xsp:expr>funksjon</xsp:expr>','<xsp:expr>passwd</xsp:expr>',
> '<xsp:expr>avd</xsp:expr>' )</esql:query>
> =09=09<esql:error-results>
> =09=09=09<section>
> =09=09=09=09An error has occured
> =09=09=09</section>
> =09=09=09<section>
> =09=09=09=09Error:<esql:get-message/>
> =09=09=09</section>
> =09=09</esql:error-results>
> =09</esql:execute-query>
> </esql:connection>
>
> this will catch errors, but I can't give the user a
> message that the task was successfull, or can I?

try update-results. also try using esql:parameter in your query.  it's
safer.

- donald