trouble using string in query (Java & MS Access)

[Brendan Cregan]

Hi All,

			ResultSet UserResult = theStatement.executeQuery("select * from gamePlayers where Username='"+ usr +"'");//check if usrname is there
			if (UserResult.next()){ //if usrname exists
				ResultSet previousScore = theStatement.executeQuery("select Score from gamePlayers where Username = '"+ usr +"'"); //check old score
				lastScore=previousScore.getInt(1);//retrieve old score
			}
			else{
				theStatement.executeUpdate("INSERT INTO gamePlayers(Username) values('"+usr+"')"); //add usrname to db	
			}

I have made a quiz servlet program and here I am trying to check if a user is there, then check their previous score, the else statement is working to create a new user in the DB if no score is present.
I'm convinced it has something to do with my syntax, but can't figure out what it is, as I have similar Queries at other sections of my servlet that are working fine.



Thanks for any help,

Brendan

[Fatih Keles]

Hi Brendan,

Can you please use proper setXXX methods for sql statements? It is not that hard and saves a lot of time when passing values to queries Here you can start.

Regards,
Fatih.

[Wendy L Gibbons]

Brendan Cregan wrote:Hi All,

			ResultSet UserResult = theStatement.executeQuery("select * from gamePlayers where Username='"+ usr +"'");//check if usrname is there
			if (UserResult.next()){ //if usrname exists
				ResultSet previousScore = theStatement.executeQuery("select Score from gamePlayers where Username = '"+ usr +"'"); //check old score
				lastScore=previousScore.getInt(1);//retrieve old score
			}
			else{
				theStatement.executeUpdate("INSERT INTO gamePlayers(Username) values('"+usr+"')"); //add usrname to db	
			}

I have made a quiz servlet program and here I am trying to check if a user is there, then check their previous score, the else statement is working to create a new user in the DB if no score is present.
I'm convinced it has something to do with my syntax, but can't figure out what it is, as I have similar Queries at other sections of my servlet that are working fine.

Thanks for any help,

Brendan

what happens if the user exists but doesn't have a previous score.
But as you haven't told us what the actual problem is, I am just guessing.

[wg] edited to move my questions outside the quote.