sqlite - Cannot select columns from Database with Android Cursor -


i'm trying grab every single row in sqlite database on android , grab each individual column each row. believe data in database, because call separate function datahelper.selectall() print out log of data. data expect correctly shows in logcat in eclipse. if it's important, datahelper.java program i'm using found here: http://www.screaming-penguin.com/node/7742. i'll post relevant code below. important stuff in dopost().

    // inside oncreate of main (which extends activity)...     button buttonpost = (button) findviewbyid(r.id.buttonpost);     buttonpost.setonclicklistener(new onclicklistener() {      // doesn't post website yet      public void onclick(view v) {       log.d(tag, "in onclicklistener.");          connectivitymanager connmanager = (connectivitymanager) getsystemservice(connectivity_service);          networkinfo mwifi = connmanager.getnetworkinfo(connectivitymanager.type_wifi);           if (mwifi.isconnected()) {           log.d(tag, "connected, calling dopost()!");           if (dopost()) {                       // ...                 }             }      }     });   public boolean dopost() {    boolean outcome = false;    long ret = dh.insert(main.id++ + "," + "my test2" + "," + "5:4:2:3" + "," + -300 + "," + -300 + "," + -1 + "," + -70 + "," + 3 + "," + -3 + "," + main.device_id);    log.d(tag, "ret static insert:" + ret);     cursor cursor = this.dh.db.query(datahelper.table_name,        new string[] { "id", "rssi", "wap_id", "lat" },       null, null, null, null, "id desc");    log.d(tag, "cursor column count: " + cursor.getcolumncount());    if (cursor.movetofirst()) {      {         httppost post = new httppost(our_server);        log.d(tag, "rssi index:" + cursor.getcolumnindex("rssi"));        log.d(tag, "the rssi: " + cursor.getint(cursor.getcolumnindex("rssi")));      } while (cursor.movetonext());    }     // release connection here?    cm.shutdown();     if (cursor != null && !cursor.isclosed()) {       cursor.close();    }  return outcome; }

now what's strange in logcat printed out full rows (just string), know i'm able access database. rssi values expect not logged, instead get:

cursor column count: 4 id value: 6 id index: 0 rssi index:1 rssi: 0 id value: 5 id index: 0 rssi index:1 rssi: 0

i'm @ loss, because plenty of online examples access data same way. have fact i'm within onclicklistener? there no debugger warnings when this.

thanks!

nevermind. turns out datahelper.java class using inserts first column. pretty counter-intuitive. that's finding code online , assuming right thing.

to fix this, manually wrote full sql statement, compiled statement, , ran it.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more