Syntax errors with SQLite query on Android

Question

I tried to do a query to the android sqlite database with the following select, but it shows only error when I put it in eclipse.

stmt = "SELECT * FROM user_zones JOIN pos WHERE user_zones.zone_id = (
                CASE  
                 WHEN user_zones.type_zone_id = 'Zone' THEN pos.zone_id
                 WHEN user_zones.type_zone_id = 'Area' THEN pos.area_id
                 WHEN user_zones.type_zone_id = 'Town' THEN pos.town_id
                 WHEN user_zones.type_zone_id = 'MicroZone' THEN pos.microzone_id END) AND user_zones.user_id = '"+id_user+"'";

Has anyone any idea about what is wrong in the above syntax? Thank you

EDIT: I cannot even run the code, there are syntax errors!

Errors:cannot find symbol class CASE

unclosed character literal
cannot find symbol class 'THEN'

expected ';' ....and so on

what is the error you got...?

Anoop
– Anoop

2012-08-20 09:08:44 +00:00
Commented Aug 20, 2012 at 9:08 — Anoop
– Anoop, Commented Aug 20, 2012 at 9:08

Community · Accepted Answer · 2017-05-23 12:04:46Z

2

If that is literally what you have pasted into your Java source, then your problem is that string literals in Java can't span multiple lines. You have to split it up using a separate string literal for each line, and glue them all together with the + operator. Like this.

stmt = "SELECT * FROM user_zones JOIN pos WHERE user_zones.zone_id = (" +
       "        CASE" +
       ...

See Paste a multi-line Java String in Eclipse

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Aug 20, 2012 at 9:10

Graham Borland

60.8k21 gold badges144 silver badges184 bronze badges

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

Collectives™ on Stack Overflow

Syntax errors with SQLite query on Android

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related