Re^7: Making a regex case insensitive

[davorg]

I have been given:

my $sql = "EXEC $SPROC ". 
          join ', ', ('?') x $procs{$SPROC};

my $sth = $dbh->prepare($sql); 
$sth->execute(@CHOICE);

But I don't understand how to apply it. Did the person that gave me this mean:

$sth->execute($Command);

No. I meant what I wrote. And I've tried twice to explain how it's used. But you seem determined not to understand :-)

Let's have one last try.

1. Create an SQL statement containing placeholders (marked by question marks) where you later want to insert values.
2. Compile that SQL using $dbh->prepare. This returns a statement handle ($sth).
3. Execute the statement using $sth->execute passing it a list of values - one value for each placeholder in the SQL statement,

Does that help at all?