I am trying to log id from users table and jobname from jobs table using user id
String select = "SELECT jobname FROM " + TABLE_JOBS+ "where userid =" +myid;
-
In your table TABLE_JOBS 'userid' is of integer type?Shivam– Shivam2015-10-31 08:28:10 +00:00Commented Oct 31, 2015 at 8:28
-
white space is missing before the "where userid="+myid; instead use " where userid="+myid;UnmeshD– UnmeshD2015-10-31 08:41:39 +00:00Commented Oct 31, 2015 at 8:41
Add a comment
|
2 Answers
"SELECT jobname FROM " + TABLE_JOBS+ "where userid =" +myid;
You need whitespace between identifiers such as your table name and keywords such as where:
"SELECT jobname FROM " + TABLE_JOBS+ " where userid =" +myid;
Comments
You're missing a whitespace before the where clause, so it gets appended directly to the table name, and you effectively don't have a where clause:
String select = "SELECT jobname FROM " + TABLE_JOBS+ " where userid =" +myid;
// whitespace was missing here -----------------------^
