07-30 21:43:57.542: ERROR/AndroidRuntime(7218): Caused by: android.database.sqlite.SQLiteException: near "(": syntax error: , while compiling: SELECT DISTINCT linenum, ordname, name, x, y, uid FROM linetable WHERE linenum =  1000(심야)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1356)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1235)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1189)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at bsb.khn.pnu.select_a.dbLoad(select_a.java:161)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at bsb.khn.pnu.select_a.onCreate(select_a.java:100)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
07-30 21:43:57.542: ERROR/AndroidRuntime(7218):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1615)

 

위는 에러메시지이구요...

db에서 1000(심야)라는 메시지를 가져오는데 에러가 발생하네요.....

자바에서도 괄호를 구분하려면 //( 이렇게 해주어야 하고 이와 비슷한 문법때문인듯 한데요...

 

db에서 이를 가져올 방법이 없을까요????

이 게시물을