Simple SQL update doesn't work :( (Probebly easy error)

[Addez]

Hello!
I'v spent my day trying to understand the built in derby database SQL thingy
And Im Finaly starting to get it! :D

Anyways, I get this problem when Im trying to modd a value:

Collums 'PWNSOME' is either not in any table in the FROM list or appears..

What Im trying to do is set the Firstname collumn value, on All the rows which have the id=8, to Pwnsome.
Now that doesnt work very well :(

Heres my code:

Statement statement = conn.createStatement();
		statement.execute("select * FROM APP WHERE ID = 8");
		statement.execute("UPDATE APP SET FIRSTNAME = Pwnsome");

What am I doing wrong?

[Addez]

AAAAAAAAAHHHHHHHHHH!
Neevermiind!! :D
I found out I must set ' marks around my string value :D

[Addez]

W8W8! No, still ONE problem remains..
It changed all my firstnames to pwnsome..
Didnt I select the ones with id 8?

[Addez]

Nvm, figured that out :P
Sry for wasting ur time..
Admins may remove this thread :P

[Eranga]

I'll keep this thread in the forum, just by closing it later.

Next time before post a question better to check all the related things, possibilities. ;)