>
> 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...
>
It's most likely the MyODBC portion of the system, rather the MySQL. I
haven't tested w/MySQL yet, but it's on my list of DBs to try sometime
in the future.
Jeff
