SQLite Database on Android Not Storing Int Properly -


i creating android application keep track of recipes. able store , retrieve recipes, is_favorite value not working correctly. when send boolean value (based on whether checkbox checked or not), correctly sent helper.insert function:

    public recipe insert(string name, boolean isfavorite, string servingsize, string time, string instructions)     {         contentvalues values = new contentvalues();         values.put("name", name);         values.put("is_favorite", (isfavorite) ? 1 : 0);         values.put("serving_size", servingsize);         values.put("time", time);         values.put("instructions", instructions);          long id = databasehelper.getwritabledatabase().insert(database_table, null, values);     }

when @ values, is_favorite 1 if isfavorite true , 0 if isfavorite false, want.

but when helper.getbyid(int id) recipe created, returns 0 is_favorite column, no matter value put in there. query pretty standard:

select _id, name, is_favorite, serving_size, time, instructions recipes _id = ?

here table creation script:

create table recipes (_id integer primary key autoincrement, name text, is_favorite integer, serving_size text, time text, instructions text);

any suggestions appreciated. if more information needed, let me know.

thanks!

update: responses! i'm still not entirely sure problem was, after force stopping, clearing data, , uninstalling app re-installing it, worked fine...

it sounds problem insert function then. sure database_table table you're selecting on? i'd experiment, , change name of "is_favorite" else , see if behavior persists our different result. have had weird issues "hidden" characters mess strings. changing name of removes conflict well.

this reason use constants keys, (instead of hardcoded keys)


Comments

Post a Comment

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

since using iframes house external pages are, accounts "not preferred method" , disallowed sites (flickr, one), want dynamically generate browser tabs. e.g., when user submits form, want dynamically generate tab on browser in response submitted. e.g., might want add new tab url like: http://www.bigsurgarrapata.com/contact how in jquery? you want form target attribute action attribute. http://www.w3schools.com/tags/att_form_target.asp browsers have ultimate control on result of target attribute open new tab value of _blank. <form action="contact_submit.php" target="_blank" method="post">
Read more

node.js - Getting the socket id,user id pair of a logged in user(s) -

i have web application done using node js , in it,i have authentication system requires users log in before can access pages. have 2 pages,the homepage , updates page. from read docs,a new socket id issued when user opens tab in browser. me being admin,i know socket id of logged in user , more so,the socket id,logged in user id pair logged in users. what method can use socket id,logged in user id pair make sure broadcast realtime info users online?.
Read more

keyboard - C++ GetAsyncKeyState alternative -

i using windows.h library's getasynckeystate function define key pushed on keyboard . here program returns int value of pushed key example. #include <iostream> #include <windows.h> using namespace std; int main (){ char i; for(i=8;i<190;i++){ if(getasynckeystate(i)== -32767){ cout<<int (i)<<endl; } } return 0; } but trying make opengl simple game , function appeared slow . there function not need cycle 180 times , if statement . thanks you're trying make opengl game, you're going use glfw. if that's case can away using glfwgetkey() such: if (glfwgetkey(glfw_key_up) == glfw_press) {...} if (glfwgetkey(glfw_key_down) == glfw_press) {...} that method nicely explained in tutorial 6 opengl-tutorial.org . should start first tutorial of beginners tutorials , later intermediate tutorials . if you're going make win32 window can listen wm_keydown or wm_keyup messages , virtua
Read more