Update field in table

[tarkowc]

com.microsoft.sqlserver.jdbc.SQLServerDataSource ds = new com.microsoft.sqlserver.jdbc.SQLServerDataSource() ;
ds.setServerName("ServerName");
ds.setDatabaseName("DBName");
ds.setInstanceName("InstanceName");
ds.setUser("user");
ds.setPassword("password");
Connection con = ds.getConnection();

Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
while(selectedRS.next()){}

String tempString7 = "UPDATE TOP " + airCardsRequested + " dbo.Assets SET StatusID=\'Reserved\' WHERE Description Like \'%Air Card%\' AND StatusID=\'extra\'";
int tempInt = stmt.executeUpdate(tempString7);

Getting the error: Incorrect Syntax near '1'. Any idea what might be causing it?

[masijade]

Do not cobble together statements like this. See the JDBC tutorials for PreparedStatement.

[Tolls]

And why escape single quotes?

[tarkowc]

How do I combine a select with an update? I am doing a select top statement and trying to update data in that selection. What is the syntax?

I thought I had to escape single quotes. I tried it without escaping the single quotes and it won't compile. With the single quotes escaped, it compiles but I get the error in the original post.

[Tolls]

This:

String somestring = "select * from mytable where name = 'somename'";

compiles, so you don't escape single quotes. Something esle was causing that problem.

Are you using a PreparedStatement yet?

As for the UPDATE:

UPDATE my_table
SET some_column = 1
WHERE id IN (your select top statement returning only ids)

[tarkowc]

The suggestion helped a little. I had to do some reading up on SQL commands and try the queries in Access to finally get this to work. Now I understand and am well on my way to creating a pretty cool program. Thanks for the help.