> From: Tony Vassilev [mailto:[EMAIL PROTECTED]]
> my $sth = $dbh->prepare($sql) || die "couldn't prepate"; What's the sql look like? What results do you expect/get? > $sth->bind_param(1, "%$names[0]%"); > $sth->bind_param(2, "%$names[1]%"); > $sth->execute() || die "error couldn't execute"; > > That method of course requires that I know the number of > bindings ocurring. > For an arbitrary number, I've been trying this: > $sth->execute || die "error couldn't execute"; Why call bind param so many times? just do: $sth->execute(map "%$_%", @names) || die "..."; HTH, Douglas Wilson
