Android rawQuery help

Posted by dweebsonduty on Stack Overflow See other posts from Stack Overflow or by dweebsonduty
Published on 2010-06-02T03:19:02Z Indexed on 2010/06/02 3:23 UTC
Read the original article Hit count: 907

Filed under:

android

|

sqllite

I was wondering how I could query my database of 1400 items and get only the DISTINCT types and row ids. Below is the actual sql that I want to run by my program crashes if I dont return ids.

 return mDb.rawQuery("SELECT DISTINCT Type from the_foods",null);

Any ideas?

© Stack Overflow or respective owner

Related posts about android

Please verify my layout: bottom button keeps coming up over keyboard

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I have a layout which does almost what I want. There's just one bug regarding the button at the bottom. I should stay at the bottom at all times. But whenever I bring up the soft-keyboard the button will be displayed above the keyboard. This is not what I want but it should become covered… >>> More
Android programming. Application stopped unexpectedly.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've just created a prototype of interface for my android app and tried to run it. Unfortunately I get an error that my app has stopped unexpectedly (my reputation doesn't allow me to post images so follow my links): screenshot of error message This is layout mode of editing. Everything looks as… >>> More
Listview Row Overlap Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I just updated my app and I am getting some odd complaints from people who update it. I am only getting complaints from people with non-stock android phones (phones that manufacturers have modified...HTC phones, cliq, pulse, etc), other phones like the Droid, Nexus work fine. My app (Photo Frame Deluxe)… >>> More
Why are some of my view not aligned correctly at the bottom of my relative layout?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problems getting some of my views aligned in a relative layout that I use inside a row of my listview. Here is a screenshot from the layout builder in Eclipse, this is what I think it should look like: The next image is from the emulator. Now the TestTestTest View is at the top and covers… >>> More
Android RatingBar weirdness: Whenever I add a RatingBar to my layout, a bunch of the generated tags,

as seen on Stack Overflow - Search for 'Stack Overflow'
Whenever I use a RatingBar view in my layout, I suddenly get all kinds of compile errors. I'm using Android 2.0, but I've also tried 2.0.1, and 2.1, without joy. I also get a message: Shader 'android.graphics.BitmapShader' is not supported in Layout Editor, and an odd warning which may or maynot be… >>> More

Related posts about sqllite

Admin GUI for sqllite?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, Can anybody recommend a good FREE Admin GUI for Sqllite? Needs to be run on a Windows PC. I tried following some of the links i found via sqllite site which states they are free.. and when arriving they seem to be charging.. I just want a good standard GUI for listing data and executing… >>> More
simple tutorial on how to use sqllite

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, im using vb.net and mssql 2005 to create an application. i was told i should rather use sqllite as i want my application to be a standalone one with embedded database. can someone please provide me with a step to step tutorial on how to create a standalone application with an embedded database… >>> More
Logging erros in SqlLite database from C# Windows Forms Application

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm developing a win app in C# which communicates to a WCF Service. I want to log exceptions that are thrown on client to be logged in Sql Lite Database (Win app is using Sql Lite database for storing data locally). And then later it should be sent to the wcf service when required so that it can be… >>> More
sqllite - sql question 101

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I would do something like this* select * from cars_table where body not equal to null. select * from cars_table where values not equal to null And id = "3" I know the syntax for 'not equal' is <, but i get an empty results. For the second part, I want to get a result set where it only… >>> More
How can i convert datetime to date formate in sqllite

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to show date in DD-MM-YYYY format in datagrid.By default SqlLite store the data in date-time format. so how can i convert date-time format to date format in flex by using SqlLite. >>> More