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

[Maria Quinn]

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