English 中文(简体)
Android que que
原标题:Android Sqlite query bind or column out of range

我从下面的问询中获得这一标志性产出。 我知道,所有各栏都在我试图查阅的表格中。 这一错误意味着什么?

11-23 23:33:48.207: ERROR/AndroidRuntime(16941): Caused by: android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x2cc688

Query:

Cursor value = checkDB.rawQuery("SELECT * FROM table WHERE open= 1  AND country= ? ", new String[]{countryID});
问题回答

You don t need quotes around the ? in the query.

使用:

Cursor value=checkDB.query(table,new String[]{"*"},"open=1 and country=" "+countryID+" ",null,null,null,null);




相关问题
Android - ListView fling gesture triggers context menu

I m relatively new to Android development. I m developing an app with a ListView. I ve followed the info in #1338475 and have my app recognizing the fling gesture, but after the gesture is complete, ...

AsyncTask and error handling on Android

I m converting my code from using Handler to AsyncTask. The latter is great at what it does - asynchronous updates and handling of results in the main UI thread. What s unclear to me is how to handle ...

Android intent filter for a particular file extension?

I want to be able to download a file with a particular extension from the net, and have it passed to my application to deal with it, but I haven t been able to figure out the intent filter. The ...

Android & Web: What is the equivalent style for the web?

I am quite impressed by the workflow I follow when developing Android applications: Define a layout in an xml file and then write all the code in a code-behind style. Is there an equivalent style for ...

TiledLayer equivalent in Android [duplicate]

To draw landscapes, backgrounds with patterns etc, we used TiledLayer in J2ME. Is there an android counterpart for that. Does android provide an option to set such tiled patterns in the layout XML?

Using Repo with Msysgit

When following the Android Open Source Project instructions on installing repo for use with Git, after running the repo init command, I run into this error: /c/Users/Andrew Rabon/bin/repo: line ...

Android "single top" launch mode and onNewIntent method

I read in the Android documentation that by setting my Activity s launchMode property to singleTop OR by adding the FLAG_ACTIVITY_SINGLE_TOP flag to my Intent, that calling startActivity(intent) would ...

From Web Development to Android Development

I have pretty good skills in PHP , Mysql and Javascript for a junior developer. If I wanted to try my hand as Android Development do you think I might find it tough ? Also what new languages would I ...

热门标签