SQL INSERT problem

[mohamed ramzy <m_...@yahoo.com>]

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...

Thanx in Advance

__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com

Re: SQL INSERT problem

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

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