| Subject: | use of prepare/execute with placeholders fails |
I have a program that works with the following system components:
perl-DBI-1.32-5
Text::CSV version 0.2002 (from the CSV.pm file)
Yet it doesn' work with:
perl-DBI-1.40-8
perl-Text-CSV_XS-0.23-1.1.fc3.rf
perl-DBD-CSV-0.22-1.1.fc3.rf
(RedHat9 with additions and FC3 stock, I believe).
The command is:
$select_command="select SEGNO, OWNER, TYPE, NAMESPACE, EXPERIMENT,
STREAM, UPDATED, SIZE from $stream_tbl where NAMESPACE=? AND EXPERIMENT
LIKE ? AND STREAM LIKE ?";
$select=$db->prepare($select_command);
$select->execute();
However, if I change the last placeholder in the select_command string
to a non placeholder, it works. I have tried changing the order of
placeholders and it is the last one.
I am currently off to find a simpler program that will show this up, but
that might take a while, and if there is a known problem with the
combination of modules I am using, then let me know.
Ta.