Skip to Content.
Sympa Menu

freetds - Re: [freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004)
  • Date: Mon, 18 May 2009 18:09:02 -0400

Buurman, H.A. (Herbert) wrote:
>
> my $ExampleQuery = $dbh->prepare("SELECT Identifier FROM Table WHERE
> Identifier = ?");
> my $Record_ref;
> my $Identifiers_ref = $dbh->selectcol_arrayref("SELECT TOP 10 Identifier
>
> FROM Table WHERE SomeCondition > 0");
> foreach (@{$Identifiers_ref}) {
> $ExampleQuery->execute($_);
> if ($Record_ref = $ExampleQuery->fetchrow_hashref()) {
> foreach (keys %{$Record_ref}) { print("$_ => $Record_ref->{$_},
> "); } print("\n");
> } else {
> print("Error fetching data for item [$_]\n");
> }
> $ExampleQuery->finish();
> }

Is this a Sybase or Microsoft server? DBI Placeholders are not expected
to work with TDS 7.0+.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page