write string 0'-1" into sqlite android database -


i cant seem right asking overlooking in code. here's i've got in code:

newleasedata = "insert " + enterlogln + " (date, "             + "stocktank1ft, stocktank1inch, stocktank2ft, stocktank2inch, "             + "stocktank3ft, stocktank3inch, stocktank4ft, stocktank4inch, "             + "change1, change2, change3, change4) values "              + "(" + today + ", '" + valuet1ft + "', '" + valuet1inch + "', '" + valuet2ft              + "', '" + valuet2inch + "', '" + valuet3ft + "', '" + valuet3inch              + "', '" + valuet4ft + "', '" + valuet4inch + "', " + diftotalt1              + ", " + diftotalt2 + ", " + diftotalt3 + ", " + diftotalt4 + ")";

everything works until strings: diftotalt1, diftotalt2, diftotalt3 , diftotalt4. each string set like: 0'-1" , 0'-2" , 0'-3" or 0'-4" , when try exec command:

mydatabase.execsql(enterlogdataoilactivity.newleasedata);

my app crashes logcat error:

06-05 04:36:23.824: e/androidruntime(1127): android.database.sqlite.sqliteexception: near "'-1", 0'": syntax error: insert (date, stocktank1ft, stocktank1inch, stocktank2ft, stocktank2inch, stocktank3ft, stocktank3inch, stocktank4ft, stocktank4inch, change1, change2, change3, change4) values ('05_05_12', '0', '1', '0', '2', '0', '3', '0', '4', 0'-1", 0'-2", 0'-3", 0'-4")

thanks know has got simple. have tried inclosing each diftotalt1 string single quote not work either (ie diftotalt1 = "'" + diftotalt1 + "'";)

this string used create table in sqlite:

newleasetable = "create table '" + leasename + "' (_id integer primary key autoincrement,"             + " date text, stocktank1ft numeric, stocktank1inch numeric,"             + " stocktank2ft numeric, stocktank2inch numeric, stocktank3ft numeric,"             + " stocktank3inch numeric, stocktank4ft numeric, stocktank4inch numeric,"             + " change1 text, change2 text, change3 text, change4 text, user text);";

you have escape quotes backslashes, i.e.

diftotal = "0\\\'-1\\\"";

this results in diftotal being "0\'-1\"" when use insert mysql.


Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more