android sqlite: Insert query syntax error [duplicate]

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
– Gordon Linoff, Commented Feb 26, 2017 at 19:08

ScaisEdge · Accepted Answer · 2017-02-26 19:17:00Z

0

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

answered Feb 26, 2017 at 19:17

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ScaisEdge Over a year ago

why downvote ... could this is not the only error but is a valid suggestio for code provided by op

Collectives™ on Stack Overflow

android sqlite: Insert query syntax error [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related