execSQL causing syntax error

Question

I have the following execSQL that is throwing a syntax error and causing my app to crash. I can't figure out why, considering I've escaped single and double quotes.

Here is the code:

database.execSQL("insert into " + TABLE_EXERCISES + " (" + COLUMN_NAME + ", " + COLUMN_PRIMARY_MUSCLE + ", " + COLUMN_SECONDARY_MUSCLE + ", " + COLUMN_EQUIPMENT_TYPE + ", " + COLUMN_STEPS + ", " + COLUMN_IMAGES + ") values ('Cable Shrugs', 'Traps', 'None', 'Cable', 'Attach a flat shoulder width bar to the lowest cable pulley. Stand with your feet shoulder width apart. Keep your abs tight and a slight bend in your knees to protect your lower back. Starting with the bar at waist height, raise your shoulders toward your ears as if you\'re saying,\"I don\'t know.\" Hold briefly at the top of the contraction then lower in a slow and controlled manner.', 'cable-shrugs-1.png|cable-shrugs-2.png')");

Anyone have any idea?

Here is the log:

12-29 23:31:54.174: E/AndroidRuntime(1207): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.gauvion.gfit/com.gauvion.gfit.RoutinesActivity}: android.database.sqlite.SQLiteException: near "re": syntax error (code 1): , while compiling: insert into exercises(name, primary_muscle, secondary_muscle, equipment_type, steps, images) VALUES ('Cable Shrugs', 'Traps', 'None', 'Cable', 'Attach a flat shoulder width bar to the lowest cable pulley. Stand with your feet shoulder width apart. Keep your abs tight and a slight bend in your knees to protect your lower back. Starting with the bar at waist height, raise your shoulders toward your ears as if you're saying,"I don't know." Hold briefly at the top of the contraction then lower in a slow and controlled manner.', 'cable-shrugs-1.png|cable-shrugs-2.png')

Could you post the part of the logcat where the crash happens please. — wow
– wow, Commented Dec 29, 2012 at 23:45
Also note that escaping single quotes in SQLite is by double-single-quotes (''), not backslashes: sqlite.org/faq.html#q14 You really should consider using positional parameters rather than hand-coding all the escaping. — CommonsWare
– CommonsWare, Commented Dec 29, 2012 at 23:46
posted the log. maybe youre right, im probably not escaping quotes and double quotes properly. — scarhand
– scarhand, Commented Dec 29, 2012 at 23:48
From that error, it definitely looks like SQLite is choking on your first single quote. — CommonsWare
– CommonsWare, Commented Dec 29, 2012 at 23:50

AndroidPenguin · Accepted Answer · 2012-12-30 00:10:51Z

you're

There's your error. You're not escaping the apostrophe. To my knowledge if you use '' this shall work.

Note: for ' use '' and for " use ""

Try this:

database.execSQL("insert into " + TABLE_EXERCISES + " (" + COLUMN_NAME + ", " + COLUMN_PRIMARY_MUSCLE + ", " + COLUMN_SECONDARY_MUSCLE + ", " + COLUMN_EQUIPMENT_TYPE + ", " + COLUMN_STEPS + ", " + COLUMN_IMAGES + ") values ('Cable Shrugs', 'Traps', 'None', 'Cable', 'Attach a flat shoulder width bar to the lowest cable pulley. Stand with your feet shoulder width apart. Keep your abs tight and a slight bend in your knees to protect your lower back. Starting with the bar at waist height, raise your shoulders toward your ears as if you''re saying,""I don''t know."" Hold briefly at the top of the contraction then lower in a slow and controlled manner.', 'cable-shrugs-1.png|cable-shrugs-2.png')");

Collectives™ on Stack Overflow

execSQL causing syntax error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related