[DBI-users] "Select count(TEST) from table where (TEST=?)" will crash with DBD-ODBC

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

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

sorry Jeff... i found today this is my fault. i have done a type missmatch
on the dbtable var... after correcting this it works now and gives correct
results... i havent't tested with MyODBC 2.5... only with beta 3.51


Alex

The obvious sanity test is that the $dbtable var is unset for some reason.
Perhaps a check of $dbtable value prior to the prepare would suffice?

Jacqui

Jacqui Caren, Ingram Group Ltd. [email protected]
ph: +44 (0) 1483 8628xx main=00 fax=01 ddi=65
http://www.ig.co.uk/ http://www.sitedirector.org/
http://www.perl.co.uk/

no - the var is set... this isn't the fault.

try to set:
my $dbtable='test_db';


Alex