freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004)
- 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
-
[freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004),
Buurman, H.A. (Herbert), 05/15/2009
- Re: [freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004), James K. Lowden, 05/16/2009
- <Possible follow-up(s)>
-
Re: [freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004),
Buurman, H.A. (Herbert), 05/18/2009
- Re: [freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004), James K. Lowden, 05/18/2009
- Re: [freetds] DBD::ODBC::st fetchrow_hashref failed: [unixODBC][FreeTDS][SQL Server]Data truncated (SQL-01004), Buurman, H.A. (Herbert), 05/19/2009
Archive powered by MHonArc 2.6.24.