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: "Buurman, H.A. (Herbert)" <h.a.buurman AT interlogica.nl>
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: Mon, 22 Jun 2009 13:21:45 +0200

> -----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 18:43
> To: FreeTDS Development Group
> Subject: Re: [freetds] Null values in result record are
> overwrittenwithprevious non-null data when using a prepared query
> morethan once
>
>
> which distro and version are you using ??

I'm using Ubuntu 9.04 server x86_64

unixODBC source was retrieved using apt-get source wich gets me
unixodbc_2.2.11-16build3
FreeTDS 0.82 was compiled with configure options:
--with-tdsver=8.0 --enable-msdblib --with-unixodbc=/usr/src/unixODBC-2.2.11/

Hmm, I previously compiled it against unixodbc_2.2.11.orig.
*recompiles*
And now it works...very odd:
Value => 1, Identifier => 1,
Value => 23, Identifier => 2,
Value => 456, Identifier => 3,
Value => , Identifier => 4,
Value => 9, Identifier => 5,

So it must've been something in unixodbc in between version 2.2.11 and
2.2.11-16b3.
Thanks for your help anyway. I hope you didn't pull out too much hair in
frustration :)

Kind regards,
H. Buurman

<html>
<body>
<pre style="font-size: 7.5pt; font-family: Arial; color: black; font-style:
italic; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; margin-bottom:
.0001pt"> <pre style="font-size: 7.5pt; font-family: Arial; color:
black; font-style: italic; margin-left: 0cm; margin-right: 0cm; margin-top:
0cm; margin-bottom: .0001pt">Disclaimer

Deze e-mail is verzonden door Interlogica B.V. De inhoud en eventuele
bijlagen zijn vertrouwelijk en uitsluitend bestemd voor de
geadresseerde. Interlogica B.V. verzoekt bij onjuiste adressering direct
contact met haar op te nemen (<a
href="mailto:info AT interlogica.nl";>mailto:info AT interlogica.nl</a>),
de naam van de afzender en de geadresseerde aan haar op te geven en
vervolgens dit e-mailbericht uit uw systeem te verwijderen.
Interlogica B.V. is niet aansprakelijk voor het overbrengen van virussen en
het is uw verantwoordelijkheid deze e-mail (en eventuele
bijlagen) te controleren. Interlogica B.V. (geregistreerd bij het
Handelsregister nr. 08067177) is gevestigd te Ecofactorij 20,
NL-7325 WC Apeldoorn.

This is an e-mail from Interlogica B.V. Its contents and any attachments are
confidential and intended solely for the use of the
individual to whom it is addressed. If received in error, please contact
Interlogica B.V. (<a
href="mailto:info AT interlogica.nl";>mailto:info AT interlogica.nl</a>)
quoting the name of the sender and the addressee, then delete it from your
system. Please note that Interlogica B.V. does not accept any
responsibility for viruses and it is your responsibility to scan the email
and any attachments (if any). Interlogica B.V.
(registered with the Chamber of Commerce no. 08067177) is resident at
Ecofactorij 20, NL-7325 WC Apeldoorn, The Netherlands.


 
</body>
</html>

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