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 64500 invoked from network); 8 Jun 2000 18:52:44 -0000
Received: from akira.webslingerz.com (HELO localhost.localdomain)
 (root@206.66.49.201)
  by locus.apache.org with SMTP; 8 Jun 2000 18:52:44 -0000
Received: from localhost (balld@localhost)
	by localhost.localdomain (8.9.3/8.9.3) with ESMTP id NAA02094
	for <cocoon-users@xml.apache.org>; Thu, 8 Jun 2000 13:43:26 -0400
X-Authentication-Warning: localhost.localdomain: balld owned process doing -bs
Date: Thu, 8 Jun 2000 13:43:26 -0400 (EDT)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: balld@localhost.localdomain
To: Cocoon list <cocoon-users@xml.apache.org>
Subject: Re: SQL INSERT problem
In-Reply-To: <20000608102353.12686.qmail@web124.yahoomail.com>
Message-ID: <Pine.LNX.4.10.10006081340260.2064-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

On Thu, 8 Jun 2000, mohamed ramzy wrote:

> hi
> i'm trying to insert data into a database by useing
> XSL XSP taglib,...i'm useing MYSQL database 
> i did the following
> 
>  <sql:execute-query> 
> <sql:driver>org.gjt.mm.mysql.Driver</sql:driver> 
> <sql:dburl>jdbc:mysql://localhost/Ramzy1</sql:dburl> 
> <sql:username>mrz</sql:username> 
> <sql:password>zocka</sql:password> 
> <sql:doc-element>ROWSET</sql:doc-element>
> <sql:row-element>ROW</sql:row-element 
> <sql:query>INSERT INTO pet   
> VALUES('<xsp:expr>usname</xsp:expr>',
>     
> '<xsp:expr>uspass</xsp:expr>',NULL,NULL,NULL,NULL)
>    </sql:query>
>   </sql:execute-query>
> 
> then i got the following error:
> 
> Error found handling the request.
> java.sql.SQLException: ResultSet is from UPDATE. No
> Data 
> 
> 
> does any 1 has any idea...

Sure, lots of 'em. What version of cocoon are you using? What database
and JDBC driver are you using? Can you send me a full strack trace?

- donald