# Why would selecting a lot of rows crash my game? [closed]

I have a databse that contains: id , playlistname , playlistnum and I want to get alll the rows where playlistname = "CoolPlaylist" and I want to parse them 1 by 1, so I thought of doing this:

String name = "CoolPlaylist";
String[] columns = String[] {id , playlistname , playlistnum};
Cursor c = myDatabase.query(TABLE_NAME, columns, key_playlistname +"="+name,
null, null, null, null);


but when I do this, the code crashes. Does somebody know what the problem probably is?

## closed as off topic by user744, TetradJul 16 '12 at 4:08

Questions on Game Development Stack Exchange are expected to relate to game development within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here. If this question can be reworded to fit the rules in the help center, please edit the question.

• I guessing it's something to do with those nulls. You need to debug the program. Read the error message, they're typically very helpful. Use the debugger, step through the code, ensure your values are set the way you expect them to be set. – MichaelHouse Jul 15 '12 at 15:13

key_playlistname +"="+name

key_playlistname + "= '" + name + "'"