What causing java.sql.SQLException: Invalid column name on my Update statement?

Question

This is my android SQL statement

I try to update the allergy table, I encounter a lot of problem

     stmt1.executeUpdate("UPDATE [dbo].[allergy] 
SET  [allergy]= "+allergyname+ ",[reaction] = "+reaction+ ",[notes] =" +notes+ " Where patientID ="+patientId);

no matter what I enter into my "allergyname"

It will say Invalid column name

what is happening?

SQL basics, literals should be in apostrophes ... also it is always better to use parameters — Selvin, Sep 12 '16 at 08:39
sorry can you give some example? my allergyname is a string variable — user2399158, Sep 12 '16 at 08:42
Possible duplicate of [SQLException: Invalid Column Name...?](http://stackoverflow.com/questions/7392296/sqlexception-invalid-column-name) — David Pérez Cabrera, Sep 12 '16 at 08:42

score 0 · Accepted Answer · answered Sep 12 '16 at 08:41

0

Your values should be in single quotes. Try below query it will work:

stmt1.executeUpdate("UPDATE [dbo].[allergy] 
SET  [allergy]= '"+allergyname+ "',[reaction] = '"+reaction+ "',[notes] ='" +notes+ "' Where patientID ="+patientId);

Happy coding!!!!!!!!!!

answered Sep 12 '16 at 08:41

Anjali

1
1
13
20

3

but still it is a bad approach ... fx `allergyname = "I'm noob"` – Selvin Sep 12 '16 at 08:47

What causing java.sql.SQLException: Invalid column name on my Update statement?

1 Answers1