On Wed, 11 Dec 2002 12:16:41 - "Ho, Tony" <[EMAIL PROTECTED]> wrote:
> In my Perl code, I declare an array, say @some_array.
> I later open a file with a column of numbers i.e.
> 1
> 2
> 3
> .
> and assign these values the array using the unshift command.
> i.e.
> while (<..>) {
> unshif
On Wednesday, December 11, 2002, at 01:47 PM, Bong Tumanut wrote:
> I just did some testing. Your SQL is
> SELECT ... IN 1 2 3
> That's syntactically incorrect.
IIRC, IN requires parens and commas:
$sql = "SELECT ... IN (" . join(", ", @some_array) . ")";
Or just:
local $" = ", ";
$sql =
On Wednesday, December 11, 2002, at 02:13 PM, Marcel Grünauer wrote:
chomp(@some_array, <$fh>);
duh. this isn't right.
chomp(@some_array = <$fh>);
marcel
--
On Wednesday, December 11, 2002, at 01:47 PM, Bong Tumanut wrote:
--- "Ho, Tony" <[EMAIL PROTECTED]> wrote:
Hi guys
I was wondering if you could help me.
In my Perl code, I declare an array, say @some_array.
I later open a file with a column of numbers i.e.
1
2
3
.
and assign these values the
L PROTECTED]]
> Sent: Wednesday, December 11, 2002 1:24 PM
> To: Ho, Tony; '[EMAIL PROTECTED]'
> Subject: Re: DBI with arrays assigned in SQL
>
>
> I'm a Perl newbie but are you generating the SQL such that it is
> syntactically
> SELECT... IN (1,2,3)
> ?
&g
Hi Bong
That's correct.
Tony
-Original Message-
From: Bong Tumanut [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 1:24 PM
To: Ho, Tony; '[EMAIL PROTECTED]'
Subject: Re: DBI with arrays assigned in SQL
I'm a Perl newbie but are you generating the
I'm a Perl newbie but are you generating the SQL such that it is
syntactically
SELECT... IN (1,2,3)
?
Bong Tumanut
DBA
--- "Ho, Tony" <[EMAIL PROTECTED]> wrote:
> Hi guys
> I was wondering if you could help me.
>
> In my Perl code, I declare an array, say @some_array.
> I later open a file with
