Re: Update Query

[Kumar Sameer]

u must be using executeQuery(query) which is expecter to return a result set. try using executeUpdate(query).

-----Original Message-----
From: tejas patel [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 17:21
To: [EMAIL PROTECTED]
Subject: Update Query

Hi all,

I have problem executing this update query.

String query= "UPDATE  BasicInformation"+
                    " SET Program="+"\'"+program+"\'"+
                    " WHERE ProjectID ="+"\'"+projectid+"\'";

My code compiled but when I execute it gave me this error

 

Exception! java.sql.SQLException: No ResultSet was produced at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:255

 

I tried running other Select query it executed fine.

 

Thanks

Tejas

---

Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards�