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

[Jim Lynch]

Yes, sorry.  I didn't take it from a running example.  I guess I should
have..

Jim.

Maria Quinn wrote:
> 
> Jim,
> 
> > my $in_clause1="('abcdef','xzyrst')";
> > my $in_clause2="('abcdef')";
> >
> > sth=$db->prepare("select * from table_x where txt in ?");
> > $sth->execute($in_clause1);
> > # that works
> > $sth->execute($in_clause);
> > # this doesn't
> 
> I'm guessing you might have just included a typo in your example, but you
> refer to a variable $in_clause, which you haven't given a value.  Do you
> mean $in_clause2?
> 
> Maria