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

[Ronald J Kimball]

On Wed, Feb 07, 2001 at 09:48:49AM -0800, William R. Mussatto wrote:
> On Wed, 7 Feb 2001, Graham Barr wrote:
> 
> > Date: Wed, 7 Feb 2001 17:07:53 +0000
> > From: Graham Barr <[EMAIL PROTECTED]>
> > 
> > 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) ...});

Since this is a Perl string (with no interpolated variables or special
characters), either single or double quotes will work just fine.

Ronald