Although version 0.45_7 fixes the case of inserting an empty string (and all of the
other bugs I reported), the case of inserting an undef string is still broken. That
is, the following code still gives the error
DBD::ODBC::st bind_param failed: [Microsoft][ODBC SQL Server Driver]
Invalid precision value (SQL-HY104)
(DBD: _rebind_ph/SQLBindParameter err=-1) at dbtest4.pl line 12.
#!perl -w
use strict;
use DBI qw(:sql_types);
my $dbh=DBI->connect() or die "Can't connect";
eval {$dbh->do("DROP TABLE table1");};
eval {$dbh->do("CREATE TABLE table1 (str VARCHAR(4000))");};
my $sth = $dbh->prepare ("INSERT INTO table1 (str) VALUES (?)");
my $str = undef;
$sth->bind_param (1, $str, SQL_LONGVARCHAR);
$sth->execute();
$dbh->disconnect;
-- Joe
-----Original Message-----
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 11:30 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: FW: CPAN Upload: J/JU/JURL/DBD-ODBC-0.45_7.tar.gz
DBD::ODBC 0.45_7
Adding support for array binding, but not finished.
Fixed bug where SqlServer Stored procedures which perform INSERT would not correctly
return a result set. Thanks to Joe Tebelskis for finding it and Martin Evans for
supplying a fix.
Fixed bug where binding the empty string would cuase a problem. Fixed and added
test in t/07bind.t.
DBD::ODBC 0.45_6
Added support for new DBI ParamValues feature.
The uploaded file
DBD-ODBC-0.45_7.tar.gz
has entered CPAN as
file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-0.45_7.tar.gz
size: 78121 bytes
md5: bfc390b932d64aac47acbf8c3a96aa9b
No action is required on your part
Request entered by: JURL (Jeff Urlwin)
Request entered on: Thu, 25 Jul 2002 17:16:25 GMT
Request completed: Thu, 25 Jul 2002 17:17:27 GMT
Virtually Yours,
Id: paused,v 1.80 2002/03/10 06:40:03 k Exp k
