Re: Update Query

[^BoyInterrupted^]

Hi Tejas,   Dont call executeQuery() for update statments. Call execute() instead. executeQuery() returns a ResultSet and should be used when you execute a query. execute() on the other hand returns a boolean value indicating the execution status of the SQL statement associated with it, hence its appropriateness for updates etc ...   regards   ^BoyInterrupted^     ----- Original Message ----- From: tejas patel To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 9:20 AM 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�