additional to this - with MyODBC 3.51 and a newer MySQL 3.23.54 it will not
work, too.
DBD::ODBC::st execute failed: [MySQL][ODBC 3.51 Driver]
[mysqld-3.23.54-nt]You have an error in your SQL syntax near
'WHERE (TEST='test2')' at line 1 (SQL-42000)(DBD: st_execute/SQLExecute
err=-1)
at C:\Inetpub\test\test.cgi line 39.
my $sth = $dbh->prepare("SELECT COUNT(TEST) FROM $dbtable WHERE (TEST=?)");
my $rv = $sth->execute($var1); # this is line 39
This select will fully work for e.g. with MySQL-Front 2.5 without any
problems...
Alex
