but I cannot reproduce this with the SQL-Studio, as you can see from my preceeding mail, it makes a difference which way the Statement is submitted:
so I think it's a perl odbc problem
When I perform the first statement via SQL-Studio like this:
SELECT CID FROM SPHERES WHERE CID=1 AND ASSAY = false
it returns one row. But when I execute the statement via Perl-ODBC ( $is_assay = "false"; $CID_item = "1"):
$sth_up = $dbh_up->prepare("SELECT CID FROM SPHERES WHERE CID=? AND ASSAY = $is_assay");
$sth_up->execute($CID_item);
it returns no row,
regards
Toni
--
Anton Epple
Genomatix Software GmbH
Landsberger Strasse 6
D-80339 Muenchen
http://www.genomatix.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
