>>>>> "Duncan" == Duncan Hudson <[EMAIL PROTECTED]> writes:
Duncan> Hi, I'm having problem's trying to dynamically create an IN
Duncan> statement for MySQL.
This is a bit of an FAQ. Please see the threads at:
http://www.mail-archive.com/dbi-users%40perl.org/msg00202.html
http://www.mail-archive.com/dbi-users%40perl.org/msg00205.html
The short answer is that any placeholder gets turned into a single
value by the time the SQL parser sees it, so you can't shove more than
one value in it (which is what you're trying to do). You can either
put as many placeholders as values, then pass all those values in with
the execute; or you can put them all into the string in the first
place, probably using DBI::quote; or you can put them into a temp
table and join it.
All of these approaches are discussed in the threads above.
t.
