Re^3: DBD::SQLite, how to pass array in query via placeholder?

At least for SQLite, I'm certain that IN does not work with arrays+placeholders the way you'd like.

Comment on Re^3: DBD::SQLite, how to pass array in query via placeholder?

Replies are listed 'Best First'.
Re^4: DBD::SQLite, how to pass array in query via placeholder? by dwalin (Monk) on Apr 09, 2011 at 19:46 UTC
Corion, Thanks, this I have found out already. ;) But if not arrayref, is there any other method of passing a set of values suitable for IN operator? That's what I'd like to know. Maybe there's some kind of magic trick... Or a way to use DBI I don't know about yet, more like it. DBI's not what I'd call simple and laconic API... Regards, Alex.	[reply]
Re^5: DBD::SQLite, how to pass array in query via placeholder? by Corion (Patriarch) on Apr 09, 2011 at 19:48 UTC
I've already shown the only way I know.	[reply]