SQLite Query to String

Question

I want to put an table content to a string if a listview item is selected.

My actual query

    public Cursor webUrlQuery() {
    String webUrlTmp = "select weburl FROM stations WHERE name=" + "'" + name + "'";
    return database.rawQuery(webUrlTmp, null);
}

works. But if I log it to logcat via

Log.d(TAG, "webUrl = " + webUrlQuery());

or

Log.d(TAG, "webUrl = " + webUrlQuery().toString());

I got something like this:

12-30 23:25:15.828: D/StationsActivity(10576): streamUrl = android.database.sqlite.SQLiteCursor@4132fce0

How can I get an string which I can use? It seems that the method, cursor.toString() dont work.

Nick Badal · Accepted Answer · 2011-12-30 22:52:00Z

1

It depends on how many results you're expecting. If you only expect one result, you could use something like this:

Cursor result = webUrlQuery();
result.moveToFirst();
String url = result.getString(result.getColumnIndex("weburl"));
Log.d(TAG, "webUrl = " + url);

Good luck!

answered Dec 30, 2011 at 22:52

Nick Badal

6711 gold badge8 silver badges26 bronze badges

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

1 Comment

Leandros Over a year ago

Yes. Thanks. Thats exactly what I want!

eldarerathis · Accepted Answer · 2011-12-30 22:44:24Z

1

Cursor.toString() is working perfectly fine - it's returning a string representation of the Cursor object. You presumably want Cursor.getString() (and I believe you'll first need to use Cursor.moveToFirst() to point to the first returned row).

answered Dec 30, 2011 at 22:44

eldarerathis

36.4k10 gold badges93 silver badges94 bronze badges

Comments

TotoroTotoro · Accepted Answer · 2011-12-30 22:44:39Z

1

Why are you trying to logcat the Cursor object? If you want to print the query, you need to use webUrlTmp.

BTW, you should really consider binding your query parameters.

answered Dec 30, 2011 at 22:44

TotoroTotoro

17.7k5 gold badges47 silver badges78 bronze badges

1 Comment

Leandros Over a year ago

I have an listview, with certain items (out of my qslite db). If on item is selected, I want to set a string to one db item. In this example above a url. Logcat is only for testing. :) But if I logcat the webUrlTmp is get only null. Why? If I use sqlite on my device (in adb) I got the right url's.

Collectives™ on Stack Overflow

SQLite Query to String

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related