Apps Parse | Check for existing data

[walla90]

Hello;

I'm currently working on a new Android app, part of the app code is to collect the users id number for each new user.

I search my life out to find a way to check if the user is already appear in the database.

I'm looking for a simple way to check if the user is exist and if so to do something else..

please help...

 

[Rukbat]

SELECT * FROM tablename WHERE USERID = 'whatever the user id is';

If you get any row returned, the used id is already in the database. (Leave out the tick marks around the user id if the field is numeric.)

 

[alostpacket]

For the love of all that is holy do not construct your SQL queries by hand!

at least bind your parameters with a question mark.... ?

[HIGH]Cursor cursor =
getReadableDatabase()
.rawQuery("select * from tablename where _id = ?",
new String[] { id }); [/HIGH]