sql statement + java

[nickyeng]

I have this statement in java....

String str = "update am_msgout set msgout_error ="+errorCode+" where msgout_id ="+cmpTxid;
 
Statement st = connection.createStatement();
 
st.executeUpdate(str);
st.close();
 
 

errorCode = "ASE";
cmpTxid = "63524";


and in the end i get this error :

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'ASE' in 'field list'
 

i have try to system print "str" before the call to sql statement....and it give me this:
update am_msgout set msgout_error =ASE where msgout_id =63524

the data i entered is not a column name in database, and it is a value shall be saved into table field.

what's wrong with my sql statement ?

[r035198x]

I have this statement in java....

String str = "update am_msgout set msgout_error ="+errorCode+" where msgout_id ="+cmpTxid;
 
Statement st = connection.createStatement();
 
st.executeUpdate(str);
st.close();
 
 

errorCode = "ASE";
cmpTxid = "63524";


and in the end i get this error :

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'ASE' in 'field list'
 

i have try to system print "str" before the call to sql statement....and it give me this:
update am_msgout set msgout_error =ASE where msgout_id =63524

the data i entered is not a column name in database, and it is a value shall be saved into table field.

what's wrong with my sql statement ?

Shouldn't it be

update am_msgout set msgout_error = "ASE" where msgout_id =63524

i.e. with the quotes?

N.B to put a " in a string in Java you use the \ escape

[nickyeng]

Shouldn't it be

update am_msgout set msgout_error = "ASE" where msgout_id =63524

i.e. with the quotes?

N.B to put a " in a string in Java you use the \ escape

thanks for the tips...

now it will be like this:

String str = "UPDATE amsms_msgout SET msgout_error =\""+errorCode+"\" WHERE msgout_id =\""+cmpTxid+"\"";
 

it runs without error but cannot update the table.....

what's wrong now...?

[r035198x]

thanks for the tips...

now it will be like this:

String str = "UPDATE amsms_msgout SET msgout_error =\""+errorCode+"\" WHERE msgout_id =\""+cmpTxid+"\"";
 

it runs without error but cannot update the table.....

what's wrong now...?

If msgout_id is a number then you do not need to put the quotes around it.

[nickyeng]

thanks again..

it is my mistake that column name in table was different with the one i wrote in the code...

haha..
my mistake

thanks anyway.
:-)