Sorry to interrupt on you on such a tragic day. I just want to let you
know that question signs ('?') inside /* ... */ comments in a
SQL-statement gives the following error message:
DBD::mysql::st execute failed: called with 1 bind variables when 2 are needed at -e
line 1.
It would be nice if '?'-characters inside comments could escape being
counted when calculating and/or expanding the number of needed
arguments.
I am running DBI-1.20, perl is 5.004_04 built for sun4-solaris.
Example code:
perl -e 'use DBI; $dbh = DBI->connect("DBI:mysql:root", "mysql", ""); $sth=
$dbh->prepare("/*root there?*/ select user from user where user = ?"); $rv =
$sth->execute("root"); @row = $sth->fetchrow_array; print "@row\n";'
Take care,
Morten