android sqlite: Insert query syntax error

Question

Hi I am trying to insert values in my sqlite database but i get "unrecognized token" for the last value exception for byte array. here is code:

 public void insertImage(String userName, String userMob, String meterReading, String readingAddress, String readingRemark, String readingDate , byte[] imageBytes) {
        try {
            mDb.execSQL("INSERT INTO " + IMAGES_TABLE +"(" + USER_NAME + ", " + USER_MOB + ", " + METER_READING_TEXT + ", " + READING_REMARKS + ", " + READING_DATE + ", " + IMAGE + ")" +
                    " VALUES (" + userName + ", " + userMob + ", " + meterReading + ", " + readingAddress + ", " + readingRemark + ", " + readingDate + ", " + imageBytes + ");");
        }
        catch (Exception ex){
            ex.printStackTrace();
            Log.e("-----","dasdasdas");
        }
        }

Use parameterized queries. That way, you won't have problems like this. — Gordon Linoff, Feb 26 '17 at 19:08
learn this http://stackoverflow.com/questions/1324641/cant-insert-byte-into-mysql-using-java — Youcef LAIDANI, Feb 26 '17 at 19:09

score 0 · Answer 1 · answered Feb 26 '17 at 19:17

seems you have 6 entry in into clause but 7 in values

try {
        mDb.execSQL("INSERT INTO " + IMAGES_TABLE + 
          "(" + USER_NAME + ", " +
           USER_MOB + ", " + 
           METER_READING_TEXT + ", " + 
           READING_REMARKS + ", " + 
           READING_DATE + ", " + 
           IMAGE + ")" +
          " VALUES (" + userName + ", " +
           userMob + ", " + 
           meterReading + ", " + 
           readingAddress + ", " + 
           readingRemark + ", " + 
           readingDate + ", " + 
           imageBytes + ");");
    }

the number of element in both clause must match

why downvote ... could this is not the only error but is a valid suggestio for code provided by op — ScaisEdge, Feb 26 '17 at 19:54

android sqlite: Insert query syntax error

1 Answers1