Android Sqlite in, Syntax---not int (?)

Processing where column_name not in (?) : If it is followed by a string of characters or combinations of numbers, it cannot be used directly (?). , and these character combinations should be used directly as part of the conditional string.

1. Where column_name not in (' name1 ', ' name2 ')

2.DB.Query (table, new String[]< Span class= "PLN" > { "id" }, String. ( "type not in (%s)" , Argsarraytostringarraysnull, null null, null

You cannot place just one '? ' instead of a list of values. As such, there is little to gain from trying to parametrize lists. One can, of course, create 2,4,16-value prepared statements but ..." type NOT IN (?,?)", new String[]{ "connect","answer" },... even in a server with remote RDBMS it had Questionab Le value. Istead, do

  db. (table, new String [] {  "id"  ,   "}, " type not in (' Connect ', ' answer ') ", null null, null , null      

If the list is a dynamic, you'll have all to escape the strings and put them into a single quoted list.

Via:http://stackoverflow.com/questions/4707367/android-sqlite-in-not-in-syntax

Android Sqlite in, Syntax---not int (?)