freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Null values in result record are overwrittenwithprevious non-null data when using a prepared query morethan once
- From: Frediano Ziglio <freddy77 AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Null values in result record are overwrittenwithprevious non-null data when using a prepared query morethan once
- Date: Thu, 18 Jun 2009 18:43:08 +0200
Il giorno gio, 18/06/2009 alle 15.17 +0200, Buurman, H.A. (Herbert) ha
scritto:
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org
> > [mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of Frediano Ziglio
> > Sent: Thursday, 18 June, 2009 15:11
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] Null values in result record are
> > overwrittenwithprevious non-null data when using a prepared query
> > morethan once
> >
> >
> > Could you try with a sequence growing and shrinking like
> >
> > Value => 1, Identifier => 1,
> > Value => 23, Identifier => 2,
> > Value => 456, Identifier => 3,
> > Value => 78, Identifier => 4,
> > Value => 9, Identifier => 5,
> >
>
> With only modifying the @Identifiers-line to
> my @Identifiers = ('1', '2', '3', '4', '5');
> and filling the table with the above mentioned data, the output
> is as follows:
>
> Value => 1, Identifier => 1,
> Value => 23, Identifier => 2,
> Value => 456, Identifier => 3,
> Value => 78, Identifier => 4,
> Value => 9, Identifier => 5,
>
> Which looks just fine. Guess which value I then Null'ed? :-)
>
> Value => 1, Identifier => 1,
> Value => 23, Identifier => 2,
> Value => 456, Identifier => 3,
> Value => 456, Identifier => 4,
> Value => 9, Identifier => 5,
>
ehmm.... fourth ?? Quite strange... which distro and version are you
using ??
> Kind regards,
> H. Buurman
>
Frediano
-
Re: [freetds] Null values in result record are overwrittenwithprevious non-null data when using a prepared query morethan once,
Buurman, H.A. (Herbert), 06/18/2009
- Re: [freetds] Null values in result record are overwrittenwithprevious non-null data when using a prepared query morethan once, Frediano Ziglio, 06/18/2009
- Re: [freetds] Null values in result record are overwrittenwithprevious non-null data when using a prepared query morethan once, Frediano Ziglio, 06/19/2009
- <Possible follow-up(s)>
- Re: [freetds] Null values in result record are overwrittenwithprevious non-null data when using a prepared query morethan once, Buurman, H.A. (Herbert), 06/22/2009
Archive powered by MHonArc 2.6.24.