On Thu, 8 Dec 2005 19:11:45 +0100 "Emanuele Zeppieri"
<[EMAIL PROTECTED]> wrote:
> my @names = @_;
> >
> > my $sql = 'SELECT name, id FROM table WHERE name IN (';
> > $sql .= join( ',', ('?') x @names );
> > $sql .= ')';
Excuse me for a silly question, but when I executed this:
@names=('q','w');
my $sql = 'SELECT name, id FROM table WHERE name IN (';
$sql .= join( ',', ('?') x @names );
$sql .= ')';
print $sql;
It gave me this:
SELECT name, id FROM table WHERE name IN (?,?)
So, where are those 'q' and 'w'?!
--
Best regards,
Strong.
---------------------------------------------------------------------
Web Archive: http://www.mail-archive.com/[email protected]/
http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
