Skip to Content.
Sympa Menu

freetds - [freetds] 1st select fails, 2nd works

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Carl Edwards" <edwards AT vitesse.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] 1st select fails, 2nd works
  • Date: Wed, 14 Jul 2004 14:58:01 -0700

Hello,

I'm running 0.62.4 with DBI 1.42 against a MSSQL server (8.0.x).

Can anyone explain why running the same SELECT statement returns
different results the second time?

The first run of the perl script shows only 1 element is returned
but when the same SQL is rerun I get the expected 8 columns?

I've attached a zip file containing the freetds-pid-log.txt
and dbi-pid-log.txt for the two identical runs.

Any ideas about what might be happening would be appreciated,
or how I could restructure my DBI calls to minimize problems.

Thank You,
-Carl Edwards


Here is a snippet of the diff of the two freetds logs:

121 ! st_next_result() -> ct_results(4043) == 1 121 ! st_next_result() ->
ct_results(4040) == 1
122 ! ct_res_info() returns 1 columns 122 ! ct_res_info()
returns 8 columns

123 ! ct_describe(0): type = 2, maxlen = 4 123 ! ct_describe(0): type
= 1, maxlen = 50
124 ! describe() -> col 0, type 2, realtype 2 124 ! describe() -> col 0,
type 1, realtype 1

130 ! 1 <- FETCH= [ 'COL(1)' ] ... 144 ! 1 <- FETCH= [
'FileName' 'UploadedDate' ...

132 ! dbih_setup_fbav for 1 fields => 0x45fcc0 146 ! dbih_setup_fbav for
8 fields => 0x4b6080

Attachment: freetds.zip
Description: freetds.zip




Archive powered by MHonArc 2.6.24.

Top of Page