Re: How do I form an acceptable string for an IN clause?

[William R. Mussatto]

On Wed, 7 Feb 2001, Graham Barr wrote:

> Date: Wed, 7 Feb 2001 17:07:53 +0000
> From: Graham Barr <[EMAIL PROTECTED]>
> To: dbi-users <[EMAIL PROTECTED]>
> Subject: Re: How do I form an acceptable string for an IN clause?
> 
> While everyone is posting thier favorite way to create a placeholder
> list I thought I would send my favorite.
> 
>   chop(my $qus = "?," x @values);
>   $sth = $dbh->prepare(qq{ ...  ($qus) ... });
Actually I think you need single quotes (i.e., appostrophy ') so it
should read: 
chop (my $qus = '?,' x @values) 
$sth = $dbh->prepare("... ($qus) ...});


Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27