Re: Null values in result record are overwrittenwithprevious non-null data when using a prepared query morethan once
"Buurman, H.A. (Herbert)" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <2864EA5D33131F4FB33903DB89A0DD360139FE31@MAILSRV01.interlogica.nl> |
> -----Original Message----- > From: [email protected] > [mailto:[email protected]]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, 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"><span lang="nl"><font color="#C0C0C0" style="font-size: 7pt" face="Arial"><i><b><u>Disclaimer</u> 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:[email protected]">mailto:[email protected]</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:[email protected]">mailto:[email protected]</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. </b></i> </font> <p> </p> </body> </html>