Re: confused about reading from database using an array

you can use the SQL "IN" statement:

SELECT id, order_num, state FROM orders WHERE names IN ("name1","name2
+","name3")
[download]

just make sure you use the $dbh->quote method to construct the quoted values.

"What should it profit a man, if he should win a flame war, yet lose his cool?"

Comment on Re: confused about reading from database using an array Select or Download Code

Replies are listed 'Best First'.
Re^2: confused about reading from database using an array by Anonymous Monk on Dec 12, 2006 at 20:49 UTC
Are you saying I can replace the list with the array? `SELECT id, order_num, state FROM orders WHERE names IN (@names)` [download]	[reply] [d/l]
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]