[jappa]

Hi there,

Im trying to insert variable value into my database. But I cant seem to do it. I am using java language. Below is my intended SQL statement . score is my variable i want to input to database.

  
SQL = "INSERT INTO lettergame (Nickname,Difficulty,Score,TimeElapsed) VALUES ('Keong','Extreme', '" & score & "','03:45:22')";
			
stmt = con.createStatement();
 rs = stmt.executeQuery(SQL);

Help is appreciated

[William_Wilson]

If you're using Java then to append strings you use the + operator, not &.

Were you getting errors before?

[jappa]

can you show me the right SQL statement for inserting the variable ?

yes it says error "Misssing ;"

[jappa]

I tried this following code to insert and it did insert the value into the database but there is an exception occur due to this

any idea how to tackle this ?

SQL = "INSERT INTO lettergame (Nickname,Difficulty,Score,TimeElapsed) VALUES(?,?,?,?)";
		   PreparedStatement ps = con.prepareStatement(SQL);
		   ps.setString(1, name);
		   ps.setString(2, diff);
		   ps.setInt(3,score);
		   ps.setString(4,time);
			ps.executeUpdate();

easyjava.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect

[jappa]

I tried to use this SQL instead and it worked but this time I get different exception error

java.sql.SQLException: No ResultSet was produced

SQL = "INSERT INTO lettergame (Nickname,Difficulty,Score,TimeElapsed) VALUES('"+name+"','"+diff+"','"+score+"','"+time+"')";

[Hary]

What are the data types of your columns? If your put something between '', it is a string/character type. If it is a numeric type, remove them.

[NewbieNeedHelp]

THANKS @ll

string myInsertQuery = "INSERT INTO test (id) Values ('"+trade.OtherSID+"')";


WORKS!!!

#CLOSED