mardi 14 avril 2015

Arbitrary SQL with NSArray as Statement Argument

I use SQLite.swift and want to create an SQL statement like this:



"SELECT * FROM user WHERE id IN({userDtoIds})"


I did



let arr:[String] = // NSArray of Strings
let stmt:Statement = db.prepare("SELECT * FROM \(tableName) WHERE id IN(?)")


But stmt.run() does not allow [String] as argument.


How can I use an NSArray as argument for an SQL Statement in SQLite.swift?


Aucun commentaire:

Enregistrer un commentaire