RE: "Select count(TEST) from table where (TEST=?)" will crash wit h DBD-ODBC

[extern . Lars . Oeschey]

> my $sth = $dbh->prepare("SELECT COUNT(TEST) FROM $dbtable 
> WHERE (TEST=?)");
> my $rv = $sth->execute($var1);  # this is line 39

I had a similar problem with a "INSERT INTO WHERE (SELECT ...)" with MSSQL.
My problem though seemed to be, that a INSERT statement doesn't allow a
WHERE clause with the ODBC drivers. Perhaps yours is related?

Lars