Thank you for a reply.
I did as you advised, my printed statement after executing the script looked
like this:
SELECT ad_id FROM help_wanted WHERE ad_id in(".join(',', 24 23 22).")
but it didn't select any records. I got the result as 0E0 for number of
found ones??
Mariusz
----- Original Message -----
From: "George Schlossnagle" <[EMAIL PROTECTED]>
To: "Mariusz" <[EMAIL PROTECTED]>
Cc: "perl" <[EMAIL PROTECTED]>
Sent: Saturday, November 23, 2002 9:00 PM
Subject: Re: MySQL
> the list in your statement needs commas
>
>
> $query = "SELECT ad_id, text_extra, life FROM help_wanted WHERE ad_id
> in(".join(',', @id_set).")";
>
>
> On Saturday, November 23, 2002, at 08:30 PM, Mariusz wrote:
>
> > I sent the following mysql query and got an error:(
> >
> > SELECT ad_id, text_extra, life FROM help_wanted WHERE ad_id in(@id_set)
> >
> > It prints correctly as:
> > SELECT ad_id, text_extra, life FROM help_wanted WHERE ad_id in(20 19
> > 14)
> >
> > but the whole idea doesn't work; what am I missing?
> >
> > Mariusz
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
