sybperl-l Archive

From: charmanp at bolon dot uk dot ml dot com (Paul Charman "LADS" X8283)
Subject: Re: Using an array in SQL
Date: Jul 31 1998 3:31PM

I do it something like this

map { $_ = "'$_'" } @array ; #put quotes round each item
$db->sql("select * from table where name in (" . join(',', @array) . ")" ) ;