java - android.database.CursorIndexOutOfBoundsException: No idea why -


i recieved error report user using android application.

java.lang.runtimeexception: unable start activity componentinfo{c`om.gurpswu.gurps/com.gurpswu.gurps.home}: android.database.cursorindexoutofboundsexception: index 0 requested, size of 0 @ android.app.activitythread.performlaunchactivity(activitythread.java:2669) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2685) @ android.app.activitythread.access$2300(activitythread.java:126) @ android.app.activitythread$h.handlemessage(activitythread.java:2038) @ android.os.handler.dispatchmessage(handler.java:99) @ android.os.looper.loop(looper.java:123) @ android.app.activitythread.main(activitythread.java:4633) @ java.lang.reflect.method.invokenative(native method) @ java.lang.reflect.method.invoke(method.java:521) @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:858) @ com.android.internal.os.zygoteinit.main(zygoteinit.java:616) @ dalvik.system.nativestart.main(native method) caused by: android.database.cursorindexoutofboundsexception: index 0 requested, size of 0 @ android.database.abstractcursor.checkposition(abstractcursor.java:580) @ android.database.abstractwindowedcursor.checkposition(abstractwindowedcursor.java:214) @ android.database.abstractwindowedcursor.getint(abstractwindowedcursor.java:84) @ com.gurpswu.gurps.player.getintfield(player.java:137) @ com.gurpswu.gurps.home.hudsetup(home.java:102) @ com.gurpswu.gurps.home.oncreate(home.java:25) @ android.app.instrumentation.callactivityoncreate(instrumentation.java:1047) @ android.app.activitythread.performlaunchactivity(activitythread.java:2633) ... 11 more`

i haven't been able recreate problem. hope can me. code on home screen retrieves values sqlite database.

 public string getstringfield(string fieldname) { string[] columns = new string[] { key_rowid, key_name, key_city, key_health, key_energy, key_rank, key_cash, key_balance, key_donated }; cursor c = ourdatabase.query(true, database_table, columns, null, null, null, null, "_id desc", "1"); if (c != null) { c.movetofirst(); string name = c.getstring(c.getcolumnindexorthrow(fieldname)); c.close(); return name; } return null; } public int getintfield(string fieldname) { string[] columns = new string[] { key_rowid, key_name, key_city, key_health, key_energy, key_rank, key_cash, key_balance, key_donated }; cursor c = ourdatabase.query(true, database_table, columns, null, null, null, null, "_id desc", "1"); if (c != null) { c.movetofirst(); int result = c.getint(c.getcolumnindexorthrow(fieldname)); c.close(); return result; } return (integer) null; }

in stack trace, first line have cursorindexoutofboundsexception: index 0 requested, size of 0. check c.getcount() before c.movetofirst():

if(c != null) { try { if (c.getcount() > 0) { c.movetofirst(); return c.getint(c.getcolumnindexorthrow(fieldname)); } } { c.close(); } }

Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more