Re^2: confused about reading from database using an array

Are you saying I can replace the list with the array?

SELECT id, order_num, state FROM orders WHERE names IN (@names)
[download]

Comment on Re^2: confused about reading from database using an array Download Code

Replies are listed 'Best First'.
Re^3: confused about reading from database using an array by Joost (Canon) on Dec 12, 2006 at 20:54 UTC
No, because you need to put commas and quotes there: `my $sql = "SELECT id, order_num, state FROM orders WHERE names IN (".j +oin(",",map($dbh->quote($_), @names)).")";` [download] Where $dbh is your DBI database handle. See also map , join and DBI's quote() method. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply] [d/l]