Android :: SQL Cursor And GROUP BY?
Nov 19, 2010
I have a query that is making use of GROUP BY so that the results are grouped by a date column. My question is this:
When I move through the cursor to get the results of the query, how can I get the multiple items associated with each group into my vector? For example, I want to get BOTH "Item X" and "Item Y" for October 16, 2010. Currently, I get them each separately.
Here is my code:
CODE:..........
So, when I get the results from my Vector, I will get:
October 12, 2010
- Item X
October 12, 2010
- Item Y
And I want:
October 12, 2010 - Item X, Item Y
Yes, I do have to change my Vector to support multiple items, but hopefully you get what issue I'm facing...
View 1 Replies
Oct 13, 2010
I've got a schedule Class, which is simply a custom ViewGroup (with custom onMeasure() and onLayout()), which enables me to place childs(=events) with LayoutParams for column/row start and column/row end. The number of childs and their LayoutParams depend on database entries.
Now I'm trying to add childs (events) from my database. I'd have to use a Cursor Adapter, so my schedule Class has to extend ListView, right? I tried that but the newView() method of the adapter is never called. Why not? My custom ListView doesn't ask the adapter for childs, no childs are added. I also can't add the childs by hand calling schedule.addView() if I extend from AdapterView.
How can I add events to the schedule with the data from the cursor?
View 1 Replies
View Related
Mar 29, 2010
The structure of some of my activities is a simple ListView with a custom CursorAdapter. The cursor is created in onCreate() on the activity from a SQLite database. The problem is that querying the SQLite database can be quite slow at times with lots of data (and let's assume I've already optimized the sql query as much as possible). Because it occurs in onCreate() on the UI thread, I get ugly black screens when opening the activity, which sometimes turn into ANRs, on a slow phone like the G1. I want to load the cursor in a background and show "Loading.." on screen while doing so. I saw AsyncQueryHandler used extensively in the framework, but this seems a solution geared more towards Content Providers and not application-local SQLite databases. I then thought of trying to load the cursor in a background thread, but realize that this might be problematic, as the CursorAdapter should be instantiated in onCreate() and should take a cursor as a parameter. The latest thought I had was to instantiate an empty MatrixCursor in onCreate() and pass that to the cursor adapter, while kicking off a thread/TimerTask to query the database. Then, on database cursor load, call cursorAdapter.change Cursor to the properly filled cursor. This doesn't seem very elegant and seems quite wasteful, however.
View 10 Replies
View Related
Mar 21, 2010
I get records from the system by quering a ContentResolver. I maintain the order of the items in the database. So I want to display the items in the order taken from my database.
How do I merge these two informations?
I am looking after an alternative way now. As what I ideally want is:
Get order of contacts by a custom order held in my database (this involves joining CR with my DB cursor, and doing an order by, later seams it's not possible with CursorJoiner) but there is more, if the join is not unique I want to sort by contact's name as last measure
Which is impossible using Cursor and Joiners, because of the missing feature of order bys, also I need to return a Cursor, as I will be using the in an ExpandableList
Also this translated to TSQL it would look like
select * from contactsdata
left join category on contactsdata.catid=category.id
order by category.pos asc, contact.display_name asc
So I am looking now after an alternative. I have in mind to load in a temporary DB table all data from CR, then do the query on the temporary table where I can join tables and do order bys? How does this sound to you?
View 1 Replies
View Related
May 6, 2009
I am seeing the exception in 'adb logcat'.But I don't know if it is caused by my application or android platform.Can you please give me any idea how to troubleshoot this exception?
View 3 Replies
View Related
May 17, 2010
How do I get the row ID from a Cursor?
View 2 Replies
View Related
Oct 18, 2009
I've got this piece of code where I count words in a dictionary and then I try to query them:
CODE:.............
The SELECT_BY_LENGTH is defined this way: private static final String SELECT_BY_LENGTH = "select word._id, word.word from word where length(word.word) between ? and ? ";
And the count works perfectly but the cursor.move(1) always returns false. I've tried to get the column count and responds with the correct count and the column names map too. I mean that the method getColumnIndex works too but I can't get any data from the cursor. All such methods fail. Am I doin' something wrong? I'm using android 1.5.
View 5 Replies
View Related
Apr 24, 2009
I call ContentResolver's query method to get a Cursor, and I would like to update the title of that row to 'new title' how to do it?
CODE:...................
View 4 Replies
View Related
May 17, 2010
How do get the row ID from a Cursor?
View 5 Replies
View Related
Jun 16, 2009
I have a Cursor points to a Contact. How can I get an url built from that Cursor?
I need to know that because from here: http://developer.android.com/guide/topics/providers/content-providers.html
I need to have an url so that I can build a phone uri, like this: phoneUri = Uri.withAppendedPath(uri, People.Phones.CONTENT_DIRECTORY);
and I can query all the phone numbers for that contact.
View 1 Replies
View Related
Jun 25, 2009
I have two tables I want to (inner) join, Contacts.People and Contacts.ContactMethods. The result will be displayed in a ListActivity. After looking into this, it appears that I should use CursorJoiner. So the code would look something like this: So my question is, how to I make a new cursor from the first two?
View 2 Replies
View Related
May 24, 2009
I have problems with Cursor in my Android application.
I have a SQLiteDatabase that return me Cursor when I try to fetch the values with :
code:.......
But I don't know how to obtain the value of the field in the Cursor.
If I do that :
code:........
I obtain the name of the columns (_id, title, body) but not the value.
View 2 Replies
View Related
Oct 30, 2009
I want to make a content provider for font file. But I can not find any way to return a Typeface from Cursor. According to SDK reference, Matrix Cursor sounds like a solution, but it doesn't support any object except String,Long,Double,Short,Flow.
View 4 Replies
View Related
Jul 19, 2010
If I pass a cursor to a simplecursoradapter, do I still need to close the cursor? if so when: after I pass it to the adapter or when the adapter is finished?
View 2 Replies
View Related
Nov 10, 2010
When i use the AVD to test my apps the cursor in the avd window changes from the windows default cursor to a custom black cursor. I would like to use the windows default.
View 5 Replies
View Related
Sep 7, 2009
I want to do customised sorting on cursor which is returned after query is done. Is it possible to do? Is there any way to do updates on Cursor?
View 7 Replies
View Related
Nov 21, 2010
I think the following scenario is common, but I can't figure the way to implement it:
We have three Activities, and one database. We ask the user for an input to search in the database. The query should get none, one or may results.
If you get none you simple inform the user.
If you get only one, you show it in a new activity with the right view.
If you get many you show them in a list to let the user to chose the right one and then you pass that to the activity which with show the data in the case of one result only.
The problem is that, in order to know the number of results, you need to do the query (and get the cursor) in the first activity. And in the case you get more than one result you need to send the data (pass the cursor?)to the list acitivty. Doing the query again in the list activity can't be right, right?
I'm aware that you can share cursors by using a content provider, but as the activities are from the same application and the data is private (useless outside), don't see the point of making it avaliable to anyone else.
I read here around that you can crate a parcelable cursor and send it in bundle, but I'm not sure if that is the right use.
View 1 Replies
View Related
May 29, 2009
I am new in Android application programming.I need to develop an android application which simply displays the cursor position (co ordinates) very urgently.If any has some pointers in same would be a great help to me.
View 4 Replies
View Related
Aug 26, 2009
When i try to edit and already stored notepad ,i see the cursor at the end of first line.I want to make it appear to the end of the text.Please help me in this.
View 2 Replies
View Related
Feb 18, 2010
I want to read my cursor position so that, after a tap, I can convert the screen x,y coordinates to a Geopoint for distance calculations.I found a snippet to convert x,y coordinates to a Geopoint and probably could use Projection instead, but how do I input those screen x,y values in the first place? This is probably straightforward, but I'm confused.The class Cursor seems to be something different than what I need
View 2 Replies
View Related
Aug 10, 2010
User wrote some text in EditText, then touched it somewhere in its field. Cursor position changed.I need to determine changed cursor position, and do some code. How can I do this?
View 1 Replies
View Related
Sep 23, 2010
My user can flick through a set of records.I save the last seen record _ID in Preferences, so that they can start off from where they left when they access the application next time.The cursor that I have extracts _ID field too.However, I don't know how to move cursor to that particular row.The following functions of the cursor need a specific position to go to :- The _ID may not be sequential (due to deletes etc).Any way to do this?
View 1 Replies
View Related
Jul 15, 2009
I was going through the notepad tutorials.the cursor was placed in the middle of edit text.i tried to make the cursor to point in the first line as shown in the pic but not able to find the solution for it.Kindly look at the pic and give favorable reply.
View 4 Replies
View Related
Aug 27, 2010
I'm trying to customize my buttons in my view a bit and give them my own look. Whenever I set a picture as a background so that the button looks different though, I seem to lose my cursor. I can use my trackball to go through the items still but when I come to one of my custom buttons the cursor does not show. I have the same problem with some TextViews that I made clickable.
View 1 Replies
View Related
Apr 9, 2009
In the android reference site, it is written in the serCursorVisible section that cursor is visible by default and you can give its value as either "true or "false" to change the its visibility on the GUI screen. But in my case , cursor is remaining invisible irrespective of setting the visibility "true" or "false" using android:cursor Visible = "true" in the layout/main.xml. Should I do something more to make cursor visible on the GUI screen or its a bug in android?
View 4 Replies
View Related
Jun 23, 2009
I'm looking for a way to insert data into a cursor that is separate from the SQL database it retrieves the rest of the information from. Is there any way to to this, or is there a different way to add more information to a list view item? What I'm trying to do is to use a date column for each entry in the list to calculate the number of days until that date (and then put that number in the list item). I know how to get the value, but I just cant find a way to put it into the list without it being in the cursor.
View 7 Replies
View Related
Jul 15, 2010
CODE:...........................
View 1 Replies
View Related
Oct 16, 2010
Is this possible? I am trying to open a SQLite database cursor in one activity, and pass it to another activity.
View 2 Replies
View Related
Jul 2, 2009
If I don't close() a cursor explicitly, relying on gc instead, may it, theoretically, cause any problems?
View 2 Replies
View Related
Oct 20, 2010
In my activity, I have an AutoCompleteTextView that gets its contents from my custom adapter. I created my adapter by following this example.The adapter works so far, but I am getting so many errors on leaks and cursors that are not finalized.My question is: how do I close the db in runQueryOnBackgroundThread?
View 1 Replies
View Related
