lundi 12 janvier 2015

sqlite converting a row result to column for listview android

I would like to display a query result (row) into a ListView (Column) with a single table. I am not sure how to do this. I was thinking of doing it with a for loop but didnt not work. Could someone help me please. I am working with 1 table.


Here is my table sample:


table name: ruling


number of columns: 75


regular search will display like this: (select * from ruling where name = charlie)


Note: the numbers are not number but block of text(full sentence / paragraph) table: ruling



name r1 r2 r3 r4 r5 ...... r75
------- -- -- -- -- -- ...... ---
charlie 1 2 3 4 5 ...... 75


I want to display is the following result



charlie
1
2
3
4
5
.
.
.
75


The reason is that with the result I want to capture it into a listView and I am not sure how to accomplish this.


Aucun commentaire:

Enregistrer un commentaire