android - SQLiteException: near "=": syntax error (code 1): (Closed) -

-

the app forces closed everytime run it. when checked logcat, error keeps on popping out.

android.database.sqlite.sqliteexception: near "=": syntax error (code 1): , while compiling: select * tblresultswheretopid=1andusname=fbbh         @ android.app.activitythread.performlaunchactivity(activitythread.java:2351)         @ android.app.activitythread.handlelaunchactivity(activitythread.java:2403)         @ android.app.activitythread.access$600(activitythread.java:165)         @ android.app.activitythread$h.handlemessage(activitythread.java:1373)         @ android.os.handler.dispatchmessage(handler.java:107)         @ android.os.looper.loop(looper.java:194)         @ android.app.activitythread.main(activitythread.java:5391)         @ java.lang.reflect.method.invokenative(native method)         @ java.lang.reflect.method.invoke(method.java:525)         @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:833)         @ com.android.internal.os.zygoteinit.main(zygoteinit.java:600)         @ dalvik.system.nativestart.main(native method)

here snippet dbhelper: top_id initialized string.

public list<result> getallresult() {       string qry3 = "select * " + table_result + "where" + top_id + "=" + "1" + "and" + user_name + "=" + user;      log.e(log, qry3);      sqlitedatabase db = this.getreadabledatabase();      cursor c = db.rawquery(qry3, null);      if (c.movetofirst()) {         {             result result = new result();             result.setresultid(c.getint(c.getcolumnindex(result_id)));             result.setusername(c.getstring(c.getcolumnindex(user_name)));             result.setaverage(c.getstring(c.getcolumnindex(average)));             result.settopicid(c.getstring(c.getcolumnindex(top_id)));              results.add(result);         } while (c.movetonext());     }      return results; }

i think there problem in concat code

string qry3 = "select * " + table_result + "where" + top_id + "=" + "1" + "and" + user_name + "=" + user;

i think should add space between table_result , where , space after "where" , same goes cocat and. also, if user_name string, need put inside ' 

string qry3 = "select * " + table_result + " " + top_id + "=" + "1" + " , " + user_name + "='" + user +"'";

Comments

Post a Comment

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

-
i trying display records table named staffpresentee database using clause... i using visual studio 2010... the table design follows- .......fieldname..................datatype........allownull 1......staff_id (fk).............numeric(18,0)......yes 2.......date........................date.............no 3......present.....................char(1)..........yes note type of 2nd field date , not datetime... i want display records table have today's date int 'date' field... current query is- cmd = new sqlclient.sqlcommand("select * staffpresentee date=" & date.now.date, cn) dr = cmd.executereader for dr = cmd.executereader error "operand type clash: date incompatible int" i tried select * staffpresentee query without clause runs correctly. try putting date value in sigle quotes maybe. cmd = new sqlclient.sqlcommand("select * staffpresentee date='" & _
Read more

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that?
Read more

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -

-
here code im = cv2.imread('luffy.jpg') gray = cv2.cvtcolor(im,cv2.color_bgr2gray) ret,thresh = cv2.threshold(gray,127,255,0) contours,h = cv2.findcontours(thresh,cv2.retr_tree,cv2.chain_approx_simple) cnt in contours: moment = cv2.moments(cnt) c_y = moment['m10']/(moment['m00']+0.01) c_x = moment['m01']/(moment['m00']+0.01) centroid_color = im[c_x,c_y] centroid_color = np.array((centroid_color[0],centroid_color[1],centroid_color[2])) print type(centroid_color) cv2.fillpoly(im,cnt,centroid_color) i getting error on last line try , pass centroid_color color argument. <type 'numpy.ndarray'> , have been able pass data type cv2.fillpoly color in other instances, not sure why having problem here. fillpoly() expects iterable, i.e. put cnt in brackets. believe duplicate of https://stackoverflow.com/a/17582850/5818240 . moreover, centroid color variable contains strings. need convert them i
Read more